Avatar of 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?

Microsoft Excel

Avatar of undefined
Last Comment

8/22/2022 - Mon
Steven Carnahan

Did you add it? I have Office 2007 however this is supposed to apply to 2010 as well

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.

It doesn't show up in that list of additional tools.
Rory Archibald

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

Ok, thank you!
Your help has saved me hundreds of hours of internet surfing.