If you have to copy them to another user's computer, you will most likely have to register them. Now you have a whole 'nuther ole control can of worms to play with.Īs for registering the controls, if you have them available in the tools, they are already registered. You will avoid other errors when copying a built exe to other computers. Re: Excel 2010 Month View Control missing are you using 64bit Office do you have any of the other controls from that library available such as 'Microsoft Date and Time Picker Control 6.0' or 'Microsoft Flat Scrollbar control 6. The MonthView control will now appear on the Toolbox. Place a check on Microsoft MonthView Control, Version 6.0. I would like to hear some opinions on MSCAL vs MonthView. Select Tools and then Additional Controls from the menu. I have found the MonthView control works fine. Since we have gone to XP it no longer works. The safest thing to do here though is to subclass the class and add the subclass to your form. We have always used the Calendar control provided by Microsoft. The controls you selected will be available to drop on your form from there. Click on the 'View Classes' button (Looks like a set of books next to the pointer) and select 'ActiveX Controls'. Now go back to your form builder and make sure your 'Form Controls' dialog is open. Keep in mind that although they are alphbetical, Microsoft controls start with 'Microsoft ' or 'MS ' as in 'Microsoft Date/Time picker.'Ĭlick 'Set As Default' to save your list. But Microsoft MonthView Control is missing in excel form controls. You can then scroll through the controls and check the ones you think you may want to add now or at a later date. Hi experts, i m new to vba, i would like to insert a date picker calendar in my VBA Form. You can follow the question or vote as helpful, but you cannot reply to this thread. I'd be happy with just an add-in for Excel 2013 for a calendar, but no luck finding one.
Microsoft monthview control missing install#
From there, click the 'ActiveX Controls' radio button. If you are running 32-bit version of Excel, generally we could take the steps you have mentioned in your thread to register the calendar control in your system. I'd like to be able to install the Microsoft MonthView Control to the toolbox in VBA, but not having any luck at all. Go to Tools->Options and click the 'Controls' tab.