Excel vbe

Question

I don't have the Microsoft Monthview Control 6.0 option in the toolbox.  I've done a repair to Office 365 with no effect.

Answer 1

SalVeltri,

Re:  using 64 Bit version

From my 64 bit library file...

  "Native 64-bit processes in Office 2010 cannot load 32-bit binaries.

  This includes the common controls of MSComCtl (TabStrip, Toolbar, StatusBar,

  ProgressBar, TreeView, ListViews, ImageList, Slider, ImageComboBox)

  and the controls of MSComCt2 (Animation, UpDown, MonthView, DateTimePicker,

  FlatScrollBar).

  These controls were installed by previous versions of Microsoft Office

  and are installed by 32-bit Office 2010.

  An alternative must be found for existing Microsoft Office VBA solutions

  that utilize these controls when the code is migrated to 64-bit Office 2010.

  64-bit Office 2010 does not provide 64-bit versions of the Common Controls."

'---

The code in my Date Picker (Get Your Own Date) was set up to accomodate 64 bit,

but I have never been able to test it on a 64 bit machine and have received no feedback from anybody on its use on 64 bit.

The program had about 10,000 downloads several years back, but the Single Document Interface (SDI) pretty much killed interest.  It requires an extra step to display the form.

It also can generate month and year calendars.

It is free and can be downloaded from MediaFire...

http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents

Feedback is appreciated.

Note:  there are multiple sources for Custom Date Pickers.

Some of which are listed below - don't know if they work properly or if they work on 64 bit.

There are others do your own search...

http://www.fontstuff.com/excel/exltut03.htm
http://www.rondebruin.nl/win/addins/datepicker.htm
http://samradapps.com/datepicker/

Answer 2

My problem is that it is not there. Also I am using Windows 10 64 bit.

Answer 3

Sal,

Re:  MonthView Control availability

Right-click the toolbox and select additional controls.

Scroll the list presented to find the MonthView control,

Check mark it and exit.