Additional controls in VBA environment.

SDR32

New Member
Joined
Jul 5, 2015
Messages
2
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?
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

starl

Administrator
Joined
Aug 16, 2002
Messages
5,969
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. MacOS
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

New Member
Joined
Jul 5, 2015
Messages
2
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

Administrator
Joined
Aug 16, 2002
Messages
5,969
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. MacOS
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,328
Members
414,054
Latest member
Sameer50

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top