Excel VBA USERFORMS #25 Date Picker Calendar revealed! Loop through Userforms and Controls Example

Fantastic Developer Tools:

[krn]

Cool, I didn't have that tool on my version and had to download and register it. Was a little bit of a pain, but I now have the date picker. Thanks Dan.

[ExcelVbaIsFun]

That's pretty ridiculously cool! Will have to check this out! thanks, dan

[OmerOmerBenOmer]

I would like to thank you for all your help and advice on how to make excel easier to use.

[ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[danjzunitch]

Very cool. I did have a glitch I wanted to mention in case others run into this. I was using Option Explicit so I had add declarations for the uf and ctl loop counters. I assumed that "uf" would be type UserForm but when I did that I got an error. It turns out you need to declare uf as type Object, then it works fine. Thank you very much!

[uniQue_XL]

Thanks a lot!
There is much easier way >> You can take the 'Microsoft Date and Time Picker Control 6.0' that is doing all you showed with the VBA code, but, the this control has already in it all you did (meaning: pick up a date and put it on the Text Box. >> F.Y.Info
By the way 2, after you add the control you can right click it and modify it... add pic. etc'...

[PemimpinRaja]

Thanx sir, its really helpful.. but if not burden you, do you have any idea how to move that red circle into our current date clicked?

[brishnafarahi]

very useful Video, if we pick the Dates from These two textboxes and want to have the number of days in other TextBox what will be the

[Ocosmas]

Hello, Thank you for your inspirational excel video. I have implemented your date picker on my work. I have some compatibility issues wondering if you can give me an idea on how to solve it. My excel file with the datepicker is located on a central server where every on the server can access it. The datepicker do not open another Computer with the same version of excel as in my computer (where the datepicker form was created.) Any idea as in what is wrong here?

[stefanbatory]

Great! And as you sad: created by great people from Microsoft :-)

[ExcelVbaIsFun]

cool! Thanks the ExcelStudio! I can't find it, do you have 2013? I have 2010. blessings, Dan

[shlerTHEnumbas]

What if you don't have the month picker as an option?

[ExcelVbaIsFun]

Dear MrTexag95,

If i understand correctly, enddate should be today's date by default? IF so, just put something on the Userform_Initialize script that says me.tbEndDate= Date


Because "Date" equals todays date, its a built in system variable.

2. Submit button, add a click event.
2a. in the code for click event, put something along the lines of

if stDate> endDate then
msgbox "that's a no-no"
exit sub
end if


range("a1") = stDate
range("a2")=endDate

[scottmarshburn]

If I have a user form and workbook with this feature and .Would it still work on another computer that does not have This Month view control installed on it?
Thanks
Scott

[adiltheprodigy]

Good, and how to show rows in listview between two dates?

[danmarked]

Hi, I need help.There is no Microsoft Month View Control on my Excel 2007. Is there any way to add it on additional Controls?

[carlosferreira]

Dear Sr., thank you very much for the classes.

I need the following help:

I want to use DTPicker in a form.

Example:

Final Date (When clicking the calendar showUp and, letting me choose the date) minus (-)
Initial Date (Follows the same procedure above).

The answer I want to showup at Label Caption.
thank you so much.

[Monduras]

is there some way to late bind the datepicker? whenever i share this with users it doesn't seem to work (even after I set all of their references the same as mine).

[denisrithaphorn]

Re:should be able to format it whenever it changes. Maybe use a Before_Update event. . .

Textbox1 = format(Textbox1, "dd/mm/yyyy")

How and were? (-:

[neftalibautista]

I can't seem to find those labels tbStDate, it would not even show hidden. Any Suggestions?