Problems finding datepicker for userform

Question

I'm running Excel 2016 Professional. I wanted to add a datepicker control to a userform, so right-clicked on the controls toolbox in the VB editor. Absolutely nothing happened, even after I restarted my machine. Thinking maybe there just weren't any controls libraries loaded, I found a linkto the mscomct2.cab file which includes a datepicker. When I clicked the link, which was readily available on MSDN, I got the following message:

Access Denied

You don't have permission to access "http://activex.microsoft.com/controls/vb6/mscomct2.cab" on this server.

Reference #18.459aa44.1464460191.c0ebbf6

Microsoft Developer Network

I usually run Google Chrome, so I switched to Internet Explorer and tried the same link with the same results.

That leaves me pretty much stuck, and I'll really appreciate any suggestions.

Answer 1

You can modify the userform (frmCalendar) in the Calendar.dotm template that you can download from the following folder of my OneDrive

http://bit.ly/1hduSCB

and have a textbox on your UserForm that has the Enter event call the frmCalendar userform which you modify so that when for example, you double click on a date, it inserts the selected date into the textbox and dismisses the frmCalendar.