How to Create Date Time Picker in Excel VBA

[@carlo9567]

Great job😃

[@DJOamen]

Thank you! Cheers!

[@miiihaaas]

It will be nice to have possibility to select different cells in background without closing date picker...

[@DJOamen]

In future your suggestion will be implemented

[@sdpattern8449]

Hello, If I changed the month from drop down then days are not changing in calender. It only shows current month days. Can you please help in getting it addressed

[@DJOamen]

See solution on the description

[@coderabbi144]

Thanks Captain. The missing code below works for both combox box CB_Mth and CB_Yr IF Me.CB_Mth.Value "" And Me.CB_Yr.Value "" Then Call Build_Calendar END if

[@DJOamen]

You are welcome, and well done, bro

[@raf4pt]

One more question please, is there a way to Hi-light today's D back color?

[@DJOamen]

You can use a conditional statement (If Statement)

[@raf4pt]

@@DJOamen I did thx. I used same White color If & modified it to be applied on Controls("D") for today, giving it a green background. Then I added: Private Sub Userform_Activate Call Build_Calendar End Sub so it can automatically show the day's color when I start the form.

[@carlo9567]

Hello. Can you help me with the following questions please: 1. How to make a selected date appear in a Textbox or more located in a Userform? 2. How to make Monday the first day of the week? 3. How to display a French version of that Date Picker?

[@DJOamen]

Watch my How to Create a Library Management System in Excel for details, of your answer. But as for the French version of that Date Picker, I can't help you. kzbin.info/www/bejne/apnYeoaFmtqnrKs

[@carlo9567]

@@DJOamen I will. Thank you

[@rishabpg977]

can i connect this to another userform

[@DJOamen]

Yes

[@eduardopimenta8799]

Good afternoon teacher, I reviewed the entire video and all the code, but the calendar was missing when we changed the month and year in combobox. So what part of the code is this event in?

[@DJOamen]

Form initialized

[@eduardopimenta8799]

@@DJOamen Initialize only loads comboboxes, but when changing the month or year the days do not change. Should the month and year change, shouldn't the days change on the days of the week?

[@raf4pt]

Changing the Month or the year doesn't change the days button!

[@DJOamen]

See solution in the description

[@raf4pt]

@@DJOamen thanks a lot, you are the best

[@sadiaalmamory1652]

How to solve the problem of (culture) when we use date-time-picker

[@DJOamen]

Change the program to meet your needs