Date and Time Picker Control on a Userform in Excel VBA

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

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

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

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

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

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.

Good video

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

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

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

Thanks a ton :)