Winsoup
asked on
Microsoft Month View Control
I am trying to create a pop up calendar in excel but I noticed that Microsoft Month View Control is no longer in my list of options in VBA. I am using Office 2010 64 bit.
Is there something that replaced this or something else I can do to make this work?
Thanks!!
Is there something that replaced this or something else I can do to make this work?
Thanks!!
Last Comment
ASKER
It doesn't show up in that list of additional tools.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Ok, thank you!
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Taken from: http://fontstuff.com/vba/vbatut07.htm
Step 5: Locate the MonthView control
The MonthView control will provide the calendar that you will place on the UserForm. It is not normally present on the Toolbox so you will have to ask for it. Right-click on the Toolbox and choose Additional Controls. Scroll down the list in the Additional Controls dialog until you find Microsoft MonthView Control 6.0 (the version number might be different depending on your version of Microsoft Office) and check the box next to its name, then click OK to close the dialog. You will see that a button for the new control has been added to the toolbox.
I tested it in 2007 and it works as show.