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

#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-2):

Fully Functional Dynamic Calendar Control in VBA (Part-3):

Please download this dynamic Calendar control from below given link:

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

************* Suggested Books *********

************* My Stuff ****************

[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).

[gokcentunal]

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

[michelenarvaez]

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!

[eleonoraa.c.]

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

[carolineodonnell]

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

[FernandoRamosOstroswky]

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

[manohartimothy]

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

[edmuva]

Excellent, best design ever, really simple and powerful.

[santhoshkumar-inqc]

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..

[manishkumarsah]

Thanks sir,

I have learnt a lot of thing from your video.

[djbcybertench]

Thank you for the very useful and informative posts on Youtube. 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.

[wasymelomda]

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

[elghaly]

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

[luizhenriquedacostajardim]

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

[ferozmahmud]

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

[bprabhuace]

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

[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.

[robs]

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..

[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 .

[SAJONY-gkfd]

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.