Date and Time Picker Control on a Userform in Excel VBA

This video demonstrates how to use the Date and Time Picker control on an Excel VBA UserForm. In this example the Date and Time Picker control is used to allow the user to populate the active cell with the date and time in a custom format.

[robertodonati]

Thank you Dr Grande for a very easy to follow and understand video.

[vasanthviswa]

Thanks Dr, is there a way i can select the date and keep and when i click on submit i can get the date, by following your video i had created nearly 9 datepicker and 9 commandbuttons and used activecell offset accordingly, also i have followed your few vids and used active cell as the first ref, so i have to cautiously select the cell and run the vba is there a way to directly select the first cell of every row where data needs to be filled instead of me selecting, and once again Thankyou so much

[javierreyna]

How can I modify the value that always appears TODAY in the current value when the user want to select the date?

[ahmedhesham-kmzl]

how to make choosing time in the same userform but seperate from the date and affecting the same cell as well ?

[eufrhil]

Thanks Dr. for this wonderful explanation. I have a problem with the additional controls tool when I click on them, nothing happens. Knowing that I have a copy of Office 2016 32-bit and Windows 10 64-bit system

[renukavashisth]

Sir I have a question I want to copy one date to next date then copy next date until another date in loop
Like in A1 I have 01/05/2020 & in A10 I have 02/05/2020 & A12 I have 03/05/2020. Now I want to fill dates in cell A2 to A9 date 01/05/2020 so on dates are not in same position
Plz help me

[sanehdeepsingh]

Very useful but my form to dates
But it met except null date(empty)

I have to enter any date to avoid error
Kindly suggest how to use date picker blank

[allabout]

Would be more useful if its polulating the cell than continue polulating automaticaly cell below.

[angelinastanton]

The steps in this video were extremely confusing for me to watch. I am not a fan of Excel VBA because most of the videos using this program are confusing. However, the finalized table was very simple to read. I think that SPSS is a bit easier to navigate most of the time.