How to Create Date Time Picker in Excel VBA
HTML-код
- Опубликовано: 21 сен 2024
- How to Create Date Time Picker in Excel VBA, in this video tutorial you will learn how to create and customise Date Time Picker using UserForm, you will also learn how to add the Date Time Picker to the Ribbon using Macro. Excellent tutorial for all learners.
Join this channel to get access to codes, perks, and see more interesting videos. / @djoamen
To support more videos from this channel, visit the Paypal link below.
www.paypal.me/...
Correction: Double click on the CB_Mth ComboBox and add the following codes below:
IF Me.CB_Mth.Value (Enter NOT = Symbol) " " And Me.CB_Yr.Value (Enter NOT = Symbol) " " Then
Call Build_Calendar
END if
And repeat the same process for CB_Yr ComboBox copy and paste the codes above.
Channel Members Download the Excel VBA Date Time Picker source codes here and modify them for their own personal use. Plus one other source code per month. Total - 2 Source codes Per Month, only:
drive.google.c...
Great job😃
Thank you! Cheers!
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
You are welcome, and well done, bro
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
See solution on the description
It will be nice to have possibility to select different cells in background without closing date picker...
In future your suggestion will be implemented
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?
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.
ruclips.net/video/4huISOeutvI/видео.html
@@DJOamen I will. Thank you
One more question please, is there a way to Hi-light today's D back color?
You can use a conditional statement (If Statement)
@@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.
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?
Form initialized
@@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?
How to solve the problem of (culture) when we use date-time-picker
Change the program to meet your needs
can i connect this to another userform
Yes
Changing the Month or the year doesn't change the days button!
See solution in the description
@@DJOamen thanks a lot, you are the best