Fully Functional Dynamic Calendar Control in VBA (Part-3)
#CalendarControlinVBA #DynamicCalendar #VBAUserform
Hello Friends,
In this video you will learn how to create fully functional dynamic calendar in Excel VBA. We have created this Calendar using VBA User forms and Command buttons. It can used in your VBA Projects.
Fully Functional Dynamic Calendar Control in VBA (Part-1):
• Fully Functional Dynam...
Fully Functional Dynamic Calendar Control in VBA (Part-2):
• Fully Functional Dynam...
Please download this dynamic Calendar control from below given link:
www.pk-anexcelexpert.com/full...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...
Пікірлер: 139
These videos were absolutely amazing, thank you so much. I never thought I could make a calendar using VBA until I saw these and it works so brilliantly!!! Thank you so much for putting these videos online.
@dharmendrasharma3541
2 жыл бұрын
Hey, can you help me, i am not able to connect the active cell with Textbox1
thank you for this video series I learned allot from it. Greatly appreciate your work.
This is probably one of the best videos about VBA I have ever seen. Well done! I learn alot from u!
@PKAnExcelExpert
4 жыл бұрын
Wow, thanks!
@Nigromancy
3 жыл бұрын
I agree! this fella is amazing!
brilliant series of videos. you are undoubtedly an excel expert, thanks a ton for sharing the knowledge with everyone.
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
What a great explanation through video series even layman can create calendar. Hats of you.
@PKAnExcelExpert
2 жыл бұрын
Glad it was helpful!
Awesome, it works flawless! Thank you for sharing your knowledge and resources.
@PKAnExcelExpert
9 ай бұрын
Most welcome🙏
I never seen a void like this! its completed and very helpful thank you very much.
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
Hey my friend, this tutorial is Amazing... I learn a lot with this... congratulations, and also save my project. Thanks so much.!!
Hello, I'm so happy I've found a Youtoube Channel like Yours. Thanks a lot. I have one tip that may help : for the 42 buttons_click codes you 're not obliged to write them one by one : I create a function that debug.print the code and automaticaly change the name of the commandbuttons. The 42 codes are written in once on the execution window. You copy, paste and You're done ! But whathever, keep going I appreciate a lot what You do !
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
Great video - to the point and very useful indeed! Thanks.
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
Thanks for a very infomative and educational video lesson.
@PKAnExcelExpert
3 жыл бұрын
You are welcome!
Thanks for these video series. They helped me solve my problem.
@PKAnExcelExpert
Жыл бұрын
Great to hear!
Thanks a lot PK....I got everything ok... thanks so much for having much patience to explain to us...
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Excellent Presentation. Thank you so much
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
really good tutorial, thank you very much for uploading this
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
This was a great project learning. Thank you
@PKAnExcelExpert
2 жыл бұрын
Glad it was helpful!
thank you very helpful this
@PKAnExcelExpert
Жыл бұрын
Most welcome
A Heartfelt thankyou.....
@PKAnExcelExpert
3 жыл бұрын
Most welcome ☺
thanks brother............i used it almost all my project........sach me tum dusre gole se aaye ho.....Thanks a lot PK......Alien
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
dear this is valuable wow thank you
@PKAnExcelExpert
Жыл бұрын
Thanks for your valuable feedback🙏
It helped a lot.Thank you.. For the Videos
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
@muralidharan9576
3 жыл бұрын
@@PKAnExcelExpert Hello! I want to add the dates to a single cell instead of active cell ...How to do it ... Thanks.
Hi! Thank you for this, I've learned a lot. One question, is it possible to call calendar when you select a datetime cell automatically?
Thank you so much
@PKAnExcelExpert
3 жыл бұрын
Welcome
Thank for sharing your knowledge with everyone, Is there way we can use this calendar in Excel Add on option?
Thank you my friend
@PKAnExcelExpert
2 жыл бұрын
most welcome
Dear Sir, I thoroughly viewed your 3 parts of the video, I would say that you are master on this subject of VB, I really want to congratulate you for having such a clear understanding and ability to make others understand the topic , so clearly and precisely, This calendar feature is available in access but not in excel since many years i was searching it , and found your video. Really Thanks for making vides like this , and sharing your knowledge with everyone. May God Bless you always...
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
G'day, awesome tutorial. Can you please make a tutorial of adding control events at runtime? I am so confused to make dynamic controls working, Thanks.
Good Morning, It is a great stuff, letting me out from office2016, 64bit trauma! Now I have integrated calander in my userform with textbox doubleclick. it works fine but i can see cursor into same textbox and a blue circle until clicking my mouse once anywhere else in myuserform. Any suggessions?
Hi PK, thanks for those great things you share with us. I want you to make a point for me. In the function selectedDate I wrote "Textbox" like that and it didn't works, when I changed "TextBox" it works! Why yours worked?
Thank you, it helped me a lot and I had a lot of fun tuning with the calendar
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
good evening sir, i sathyanarayanan from vellore-tamilnadu, i have seen your calander coding which will be usefull for all. even though i very much impressed on your calander, since i am accountant in a manufaturing company past 20 years , after seeing this i thought of learning vba , is it easy to learn? since i know foxpro- but i like this.( tell me where to start to earn this) Thank u very much. with regards v.g.sathya bey
Hello, very good work ! However I would have to add a "0" before the numbers 1 to 9 in the calendar. How can I do this ? Sorry for my English. Thanks
Thanks Mr. Kumar. Really enjoyed the vidoe. Your explanation was on point. But I have found an issue. As you said when you select a cell with date and click the command button the star will be displayed in the selected date but this doesn't work for next year. For example if I select today's date and then I select the same date for next year and later when I select the next years date and click the command button the star doesn't move to the next year. May I know any solution?
Hi, sir About Part3 last 2 mins,the commandbutton demonstration ,textbox already exists date value, but calender no highlight star image, I have the same situation.how can I do? Thank you!
I'm really happy to watch such video. My current issue is my selected date doesn't appear on the desired textbox. Is there any possible fault you can predict?
Yes, it is amazing, thank you very much. I have a problem with showing the star, I could not figure out how to download the Excel file "from the link given in description box"
All the parts of this video are very helpful and informative. Kindly help regarding one thing. How to highlight the current day. I would like to show the present date at the time of run. Where at the beginning it is showing current month and current year in the drop down. As addition I wish to highlight current day. Kindly help
hi and thank you. I've followed your guide to the letter and have made the calendar etc. but when I use call calendar.SelectedDate (me.textbox1) in a userform for some reason it doesn't show in the text box I've selected. can't figure out why? I've gone over your video and it works when you do it but on mine the calendar shows up, allows me to pick a date but then doesn't put it in the textbox? :(
Hi PK, I want your help please ! I'm done with the calendar and it works in more than one workbook that I have, I discovered now something wrong, I can select November 30, 2019! When I select it return no value in the TextBox! But others work really well
Hi.... Thanks for your time and your knowledge..... I watched the three tutorials and followed them by creating a calendar userform... All OK except that I get cm buttons for 30 days of February and only 30 days of July and August..... Please advise how to fix this.... Thanks
first a big thanks for sharing this awesome calendar, I am struggling to add the date to a specific cell as I don't want it to show on any selected cell when I open the calendar, instead to fix it to one specified cell, hope you can help me with this
Awesome, this is what i was looking for...appreciate and expect more complex application development tutorials from you for knowledge. I am working on jewellery workshop managememt application. If you have any suggestion or assistant, i will be thankful.
@Rockandroll29
4 жыл бұрын
there are 2 things missed or bug, 1. When any date is selected or typed in cell then only the date will be highlighted in calender and the month & year will not change i.e. if in the cell the date is selected or typed is 10 Oct 2019, then in the calender, only 10 (Date) will be highlighyed and month will remain same(current month and year). 2. While using this calender in any other form, the first code to pull the calender doesn't work i.e. call calender.selectedDate (Me.Textbox1) I am not sure how this 2nd bug worked in your version. Kindly assist.
@rajpahan5588
10 ай бұрын
@rockandroll29 It's not an bug please check your code once, in the variable there might be some spell error which is not letting your function to work on please fix that.
Awesome calendar!!! Your channel has some very good content. Can I use this on a worksheet with Selection Change on a cell in a worksheet? How would I do that?
@brenthalbach3645
3 жыл бұрын
I can get the calendar to work with selection change code like below on a worksheet, but the selected date does not turn to white back color on the calendar and show the star. Any ideas? Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("L10")) Is Nothing Then Range("L10").Value = Calendar.SelectedDate End If End Sub
If i have 30 worksheet in a workbook(eg. Like timesheet for a month) In a plain sheet i have to select the date that should popout my selected date sheet.. Please guide me how to do this
Hello sir thank you very much for video. I can't able to run highlight procedure.plz give code
Hello! Thank you so much for your videos. I'd appreciate it if you could help me if one little hiccup. last part of the dynamic calendar. I can't link the commandbutton1 to display the Date on textBox1. It shows the calendar, but when I click any date. It does not show in TextBox1. What am I missing?
I'm having issues with the Calendar at the end. Does all this code have to follow a certain order? Is there a way to print out the code? Or get a physical copy?
sir thank you so much for helping all of us in designing a calendar but i am facing a slight problem in it. after calling the calendar from call function at last and if i choose the same date of the default i.e. present month it is highlighting it thats good thing but when i am choosing any date of any month except the current one, it is highlighting that date on present month.. for example, today is 25th oct but if i choose 14 nov, it is highlighting 14 oct.
@angellamariedubouzet4225
Жыл бұрын
same problem. did u solve it?
Sir Is there any technic to install permanently this calendar in toolbox.?
Hello, Unfortunately the inserted date is not in the date format. Can this be changed immediately in the Vba code?
How can i get the date in textbox1 like this in this form for example: 04.05.2019 (not in this form: 04 Apr 2019) Thank you for your help
Dates not getting highlighted with star image? What's the issue?
sir , highlight date no working how can i solved that reply me plz. stay safe.
I am making your vba calendar. Everything works until the step where I click on a date and my date is supposed to appear in my textbox1 box at 4 min 40 second. I don't have any dates written in this box. I am discouraged. For what. Thank you for your help. Audrey
use 2 textbox how to do and if select date on month /year why calendar not show date that select it show current month pls suggest
Hi .. I have a problem .. I can't show the dates in the active cell but I can show the calendar ..
School software teyar hua ki nahi please Bataye sir
hi sir thank you very much for this video. i have only one question, i am working on this calendar tutorial and im in the 7:26 part of the this video,while im creating it,i having trouble making the date clicked appear in the activecell. i repeated it step by step but still not working.thank you very much to your response.
@dharmendrasharma3541
2 жыл бұрын
Hey, i am getting the same problem, did you solve it
Could it be activate the blank buttons? These blank buttons would be the days of the previous month and the days of the month after, could it be used by clicking on the days of the previous month and the days of the month after?
thank you for the tutorial but for months 5,8,10 and 12 it's not a date format but text....please give us the solution
Hey pk, can u do video save as format excel I vba? Ex: save as from. Xls format to . Xlsx and different formats
@PKAnExcelExpert
5 жыл бұрын
Hi, I will make such video very soon. Thanks for your suggestion.
sir, star image no showing in particular date. how to solved that? please help me?
@muhammedshaheryar6715
3 жыл бұрын
same problem & compilE error ALSO, SUB or FUNCTION NOT DEFINED HOW CAN FIX THE ERROR,& CALENDAR NOT SHOW, MARK error (call show_date)
Hi i have created based on your video now saved and I moved this user form another xlsm file but not running come for error Error is Compile error ( can't find project or librery )
Great video my friend very very helpful but i am stuck in a very small thing in the last i create another userform as you told but when i click on commandbutton and select the date it doesn't appear in the textbox and the second method does working but i want first one because my another project getting disturb through this I can't select any date for any textbox please help me out from this situation 🥺
@The_Zaibilization.
2 жыл бұрын
I solved it by ur examples 😍😍😍 thank you brother ♥️
at the end of the video the star does not appear when the textbox already has a selected date, sorry my english, thanks....
Sir isme 2 June select krne pe month february ho jaa rha h
Good afternoon Sir, How to convert it into an add-in ?
Where to get the raw data file from
I am getting compile error "method or data member not found. I am not able to found textbox1 in another userform
@PKAnExcelExpert
Жыл бұрын
The "method or data member not found" error in VBA typically means that the code is trying to use a method or property that does not exist, or is misspelled, in the referenced object. In your case, it seems that the code is not able to find "TextBox1" in another userform. Here are some possible reasons and solutions: Check if the userform name and control name are spelled correctly. Check if the userform is loaded: If the userform is not loaded when the code is executed, VBA will not be able to find the control. Make sure that the userform is loaded before referencing its controls.
Here it won't run the FUNCTION selectedate in my vba they directly go to debug code🙁🙁 help Pls🙏🙏
Thanks sir textbox me enter kare to word me month aaraha hai eske liye code bataye help me sir
The code Call calendar.selecteddate(active cell) Does not work Cell does not display the selected date
Sir I created and apply in my form but There was a problem with this. When calendar popup date of textbox not highlighted and my form's textbox value not updated ? Without update when I close calendar then my form's textbox value show empty ??? Please solve my problem How can I send you my workbook for solve my problem ?
Hi PK, Thank you so much this knowledgeable video tutorial, however the calendar control you have build is for Indian Standard Date, not for US Standard time, suppose somebody is working in a company where the client is US client then he/she need to enter the date in MM-DD-YYYY format. I checked that your Calendar control form is giving the date in DD-MM-YYYY format. Can you please make a tutorial for MM-DD-YYYY format Calendar Control. Thanks Kashif
@PKAnExcelExpert
5 жыл бұрын
Hi Kashif, Thanks for your valuable feedback. I have used D-MMM-YYYY format not DD-MM-YYYY format. So It will work everywhere because it will give the output as 1-Jan-2019 not 1-1-2019
I think there is bug in this code, you only showed the dates for the current month in the video. But when you change the year and month and then reopen the calender while having that cell with the date selected then the month and year caption on the top does not change. it will continue to show the current month and year not what was in the cell.
Hi PK.... I have made this Callander as per your tutorial, but when I run in excel I can take new selected date but when I go to edit following date, in user form shows cell date, but month and year combo box show present values. (ie 28-Aug-1998 but in user form 28-May-2020) Please give the solution
@issacsoo1181
4 жыл бұрын
I have same problem,how to solved? Where part getting wrong??
sir the error still show (compile error {sub or function not defined} Sir how can I fixe this please send me the right code
Sir please Send this Practice File
@PKAnExcelExpert
4 жыл бұрын
Link is available in description box
While making this vba I having a problem with elself vba.typename (target control) = "commandbutton" or vba.typename(targetcontrol) = "label" then. I type this and press enter it will give a error compile error : expected : end of statement sir how to solve this please help
@runtime_engineer
3 жыл бұрын
Do you have "End If" code below it?
Hello! Please write me the code to change the date format to 01.01.2023, as an example. Thanks
@PKAnExcelExpert
Жыл бұрын
Will create this option in next version. meanwhile you can change it from number format using custom format as "DD.MM.YYYY"
@Murka-Mur
Жыл бұрын
@@PKAnExcelExpert У меня не получается, напишите каким образом и куда вставлять код. Спасибо!
do you have a fully functional calendar
@dharom1
Жыл бұрын
link please
Sir.. I've watched all three vidios regarding calander & also i made it.. But textbox on calendar not showing date on active cell date... After all codes in selected date subroutine it is not worked as per your vidio.... why.. Pls guide me Waiting for your genuine reply..... Thanx...👍
@tashingamaroveke208
3 жыл бұрын
also experiencing the same headache wonder if you figured out how to solve that one
How to highlight automatically today?
@rolfarneberg9182
2 жыл бұрын
If Me.TextBox1.Value "" Then Call Show_Selected_Date(CDate(Me.TextBox1.Value)) Else 'ny Call Show_Selected_Date(Date) 'This highlight automatically today if cells empty End If
@MuhammadShahAlam99
Жыл бұрын
@@rolfarneberg9182 Thank you so much.👍
I get error When I click on command button What is the problem ?
@VBAGYAN
3 жыл бұрын
Problem Solved
Hi bro... until 2nd part my code is excecuting well... but in 3rd part... as per the active cell date, the calendar is not changing... COuld you please guide on this If you can please provide me your email address.. i'll send you the file.. Thanking in Anticipation.
SOLVED : I found my mistake. :) need help. I am getting a invalid qualifier at "Calendar" when I did "Call Calendar.SelectedDate(ActiveCell)" I reviewed the vid couple of times but i am getting the same error.
@pdlhandsomee
Жыл бұрын
Hey, i am getting the same problem, did you solve it
@marchelsarmiento8702
11 ай бұрын
hi can you please tell me how you solve it? thank u
Hi sir. I encounter problem to show the selected date in the textbox assigned. But if assigned it to show in label. The date is displayed. How can i show the selected date in my textbox