I am trying to get the 'datepicker' (MonthView) ActiveX control toolbox in Excel 2010 as part of a Excel UserForm I have created. I have spent all day trying to find a solution for my problem. I opened up the 'more. ' but the MonthView/datepicker/calendar control is not listed. Excel VBA Forms Part 18 - Installing the Date Time Picker and Month View Controls. Date and Time Picker Control and the Microsoft Month View Control and explains how to add them to your User. How to Install Microsoft Date & Time Picker Control 6.0 (SP4) In the posting “ Insert a Drop Down Calendar Menu In Excel – Choose a Date! ” one of the steps requires that you select the Microsoft Date & Time Picker Control 6.0 (SP4).

I'm trying to use the Microsoft month view control in Excel. How do I check if the user has picked a particular date using if statements?

1 Answer

I would recommend not to use monthview control. You may use this alternative

If you still want to use the monthview control then see this

The MonthView1 controls return a string value which can be accessed by MonthView1.Value

And once you have the string value, you can convert that to a date value by using CDate()

For example

Now it is easy for you to use an if condition to do a direct date comparison.

Not the answer you're looking for? Browse other questions tagged excel-vbavbaexcel or ask your own question.

Microsoft Monthview Control 6.0 Sp6 Down…

I had an Excel form built in Office 2003 with a Calendar Control to pick a date. I updated the form to run on 2007 but the control wouldn't work so I took it out. I now understand there is a MounthView Control 6.0 but it's not in my Toolbox. I've been reading all sorts of stuff about adding Active X files, changing files in the registry and all sorts of other stuff. I can't believe that Microsoft has made this so difficult. Is there not a place where a newb like me can click and download this calendar control?