Please note that Date Picker is not available in 64-bit Excel. Step by step on how to fix ActiveX Date and time picker and also for MonthView missing in Userform. These 2 controls uses same file. Mainstream Support for Microsoft Visual Basic 6.0 ended on March 31, 2005. However, we are releasing this non-security related package because it contains improvements that were ready for release just prior to the end of Mainstream Support. Microsoft Visual Basic 6.0 has transitioned to Extended Support which runs through March 31, 2008. I would like to add a calendar to my userform but for some reason I cannot find the Microsoft MonthView control 6.0 in the list of additional tools for the userform. Find out steps to fix How To: Monthview Control Missing In Office 2016. Klipschorn serial number decoder.
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?
Active4 years, 11 months ago
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?
Community♦
MuziPMuziP
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.
Community♦
Siddharth Rout![Microsoft Monthview Control 6.0 Missing Microsoft Monthview Control 6.0 Missing](https://darrenmyher.files.wordpress.com/2012/08/image_thumb14.png?w=551&h=303)
![Control Control](https://i.stack.imgur.com/FcOjM.png)
Microsoft Monthview Control 2016
122k1515 gold badges163163 silver badges218218 bronze badges