For Windows 8. Right-click the Start button. Click Control Panel. If your Control Panel view is set to Category, from the drop-down menu next to View by choose Small icons. Click Administrative Tools. Double-click Disk Cleanup. If you see a drop-down menu with a list of drives, choose the drive you want to clean (generally the C drive). Using Microsoft office 2010. Cannot locate Microsoft MonthView Control 6.0. Right clicked on tool box but am unable to see that control add on. Where can I go to get it.
![]()
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 Month View 6.0 ProSiddharth Rout
123k1515 gold badges163163 silver badges218218 bronze badges
Child Development 0 6 MonthsNot the answer you're looking for? Browse other questions tagged excel-vbavbaexcel or ask your own question.Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |