Fully Functional Dynamic Calendar Control in VBA (Part-1)

[@TheRealMake-Make]

I’ve been working with VBA for two years and never knew you could click and drag a user form to copy it to another workbook. Holy cow, this changes everything-thank you! 5:32 (I’m inserting a time stamp because my fat fingers keep closing the video).

[@michelenarvaez9271]

THANK YOU! This is incredible! I watched it while working out (which is normally boring) but this made the time fly by! Very clear instructions and good speed. I’m so excited to use it!

[@PKAnExcelExpert]

Glad it helped!

[@michelenarvaez9271]

@@PKAnExcelExpert thank you! Is there any way to highlight the current date?

[@gokcentunal8672]

thank you, i tried many ways, many videos but with your solution, it took only 15 mins. thanks a lot

[@eleonoraa.c.1706]

You are brilliant, thank you very much, your lessons helped me a lot! 🌻

[@PKAnExcelExpert]

Most welcome🙏

[@manohartimothy5825]

I forget to thank you for the calender program and the data management system..its really great......

[@PKAnExcelExpert]

Glad it was helpful!

[@edmuva]

Excellent, best design ever, really simple and powerful.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@FernandoRamosOstroswky]

Fantastic!!! Thanks from Brazil... I was looking for this calendar... Now you have a follow from Brazil

[@carolineodonnell8458]

Thank you so much this is incredible! You are a true lifesaver! I CANNOT thank you enough!!!!

[@davecks3042]

Thank you. You are truly an expert.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@wasymelomda897]

you're amazing really amazing, i was looking for that along time ago, really shapoooooooooooooo

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@manishkumarsah5417]

Thanks sir, I have learnt a lot of thing from your video.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@norulzanamohamedsamuri1364]

finally diy datepicker..... thanks so much

[@rajamanickamramalingam8786]

Execellent tutoral 05:32

[@PKAnExcelExpert]

Thanks

[@santhoshkumar-in3qc]

absolutely mind blowing.... was searching for this for many days.... truly a gem you are bro... Please post the videos of VBA userforms more and more..

[@PKAnExcelExpert]

Sure I will

[@elghaly2020]

Thank you very much bro, You are Amazing. Very Helpful.

[@PKAnExcelExpert]

Happy to help

[@djbcybertench]

Thank you for the very useful and informative posts on KZbin. Can you please tell me where I can alter the VBa code on the calendar to change the week start day to Monday, rather than Sunday as per your code.

[@carlo9567]

Wow!!!!!! Good job

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@robs4911]

Love your videos super knowledgeable.. i just have one issue in the sub show_date ..last_date = VBA.DateSerial(Year(first_date), month(first_date) + 1, 1) - 1 ..it points to the Month and gives me a "wrong number of arguments.I have followed your intruction perfectly cant figure out why. Please Help..

[@poeticnight9339]

Its really appriciateable....!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@luizhenriquedacostajardim5511]

Sensacional. Ajudou muito. Muito obrigado. (Sensational. It helped a lot. Thank you very much.)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@CarrierRates]

Nice, very nice work on both the calendar and video. Good Job! Thank you. I have followed along the video and have it working, but not sure if I missed something or if it was left out. Which is if I click on a cell that has a date the calendar open to the correct day, but not to the correct month or year. Was the correct month, year left out of your project or did I miss something in the video? I am using Excel 2019 download. Would you happen to know what versions of Excel this calendar will run on? Thank you in advance for your response. Enjoy.

[@awnikarkazan7488]

Just Wonderful Wow!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gausselim1474]

I added a little calendar icon inside my image box. When I clicked it twice to bring up the Private Sub code, it said Image1_BeforeDragOver(ByVal Cancel as MSForms.ReturnBoolean,......) It should say Image1_Click(). Why is that happening to me?

[@ferozmahmud5552]

You are great sir....thank you very much. Can I be your student?????

[@bprabhuace]

HI , I made calendar form . Thanks . Its a wonderful video . Can you help me to insert this calendar form in another form .

[@indiavikas-computer]

Love u brother Thank you

[@PKAnExcelExpert]

Thanks

[@indiavikas-computer]

Sir how to change the format of date in textbox

[@Fazwaans]

Thanks for sharing this video and this calendar, I having problem with this, When i open Calendar, It dos not high lighthe Pc date .

[@nora1784]

Hello. After using the date picker, I need the dates to show as ranges in 2 different columns. How can I edit the code to do so??

[@dalitsotembo603]

Hello, am failing to use the calendar after installing a 2021 Microsoft Office. It seems the new update does not recognise the date function. Any help?

[@mastg99]

Sir how to make next & pervious button Or if you have any video please send video link thanks

[@afghaninadjib4628]

can i change commandbutton with label? cz i can't make the commandbutton to flat design, i dont wanna has shadow on my design

[@prashantmeher6260]

Thanks for calender

[@PKAnExcelExpert]

Welcome

[@bezualemfisseha2119]

thanks

[@PKAnExcelExpert]

Welcome

[@SAJONY-gk7fd]

Awesome Sir, your tutorial very understandable. Would you tell me please! how to insert Every Date between two date range into my table. I Use MS Access Application. I create a sample form and add there two date text box and a command button. Now I want to insert first date and last date All value. how to write code for this work. I try to create but can not. I am from Bangladesh, I will be very happy if you answer me.

[@BestFriendsForeverTrue]

Nice 😍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@niveditarajput896]

Can I not change the color of the number buttons?

[@umefarwa1899]

Kindly sir tell me one thing when I take command button there opens codding what to do for alignment of buttons

[@manohartimothy5825]

I just wanted to know how to access the selectedDate function or method......

[@abmujahid]

Hi, I have got Compile error in the year section (With Me.cmbYear) it says Method or data member not found. Could you please help me in that matter?

[@malikstudio7331]

hi dear sir very nice kaya yahi calander access 2013 may is ki vidio mil sakti hy thanks waite for answer

[@rsiddique1584]

Sir calendar automatically download ho jaye

[@hamdanfaisal9503]

Sir, i can not upload Picture (msg is Invalid Picture)

[@rsiddique1584]

Sir direct bata do kaise calendar download kare

[@umefarwa1899]

Kindly help me regarding this I have completed video 1 process and couldn't retrieve the file coz after completing that video I stopped it and continue now but couldn't able to extract

[@rc7184]

i am not able to take value property as when i am running error 380 come up. why is it coming sir??

[@KGNPATAL]

in my project getting this line error"Set btn = Me.Controls("CommandButton" & i)" type mismatch runtime 13 please help Mr PK

[@Sebastien_Frederic]

Thanks , interesting!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sujeetvichare5825]

@@PKAnExcelExpert We want to watch this video 1 part 2 part and 3 part?

[@yogesyoges2143]

but the coding year not showing in calender

[@carlo9567]

What if I want Monday to be the first day of the week?

[@PKAnExcelExpert]

We need to modify the code accordingly.

[@SantoshSharma-ty6bh]

"Can't find project or library" - this error i m facing while creating this.

[@aimare19]

thanks u SIR you be like Fast and Furious hhh

[@9035451964bose]

Hi Pk sir

[@manohartimothy5825]

i cant get the Calendar.selectedDate function.....is there any other option to get the calender call to a me.txtDate

[@chunlanwei8922]

me too . how about now？

[@TheLaopi]

Hi i'm from France and i would like to start the week days with monday how can i do thanks, best regards i follow all your videos

[@M4R3K0001]

Hi, click on userform and find this part: If VBA.Weekday(first_Date) = i Then and change it to: If VBA.Weekday(first_Date, vbMonday) = i Then Additionally in userform move day names left one place and place Sun right next to Sat

[@dharom1]

all is good but i cant open it is a error showing

[@dharom1]

😭

[@9035451964bose]

I need help unable to call calendar

[@charlesthamba4514]

How can I download the second part?

[@PKAnExcelExpert]

Link has been given in videos description box

[@manishsharma-go2fi]

I cannot add picture of arrow

[@Swamhtetyan]

Hello Sir , I can not download your file , Please How to down load ? Thank Sir

[@PKAnExcelExpert]

Download link is available in videos description box. Below is the web page link. www.pk-anexcelexpert.com/fully-functional-dynamic-calendar-control-in-vba/

[@rayhanulislam4104]

My year code does not work.

[@indiavikas-computer]

#qna Sometimes it works fine but sometimes when i click on the date The exisying will disappear without any error what to do man 😡😡😡😡😡😡

[@technicalsupport8641]

bro what is password of Calendar Control in VBA file

[@b3lg4r4th8]

This doesn't work

[@alisharifi7781]

This is not so good because for one creates calendar you making 2 videos why not complete sir in one video completely confusing video