Additional controls in VBA environment.

[SDR32]

Hello, I am using Excel 2013, recently I have been dabbling with VBA. I have been working on a user form for my job. One of the fields in the user form requires a date selection. In other threads and forums I have found how to add the additional control to make this calendar/date selection in VBA environment. However when I open the additional controls from the tools menu I can not find the Microsoft month view 6.0. It simply isn't in the list! Any help with this?

 

[starl]

It's not part of the Excel package. You could steal it from elsewhere, but your application wouldn't work on other machines unless you installed it there too. The best thing to do is create your own date picker tool using standard controls.

 

[SDR32]

It would be very helpful to get an example of both methods does anyone care to explain to me how to make a date picker with the standard controls

 

[starl]

You can search online for examples.
Here's one that works in multiple versions, but it works for 32bit Excel only. It can be modified for 64bit if needed. Don't recommend trying to create one workbook to work in 32 & 64bit.