PDA

View Full Version : Calendar without add-ins



sconly
06-22-2011, 03:42 AM
Is it possible to create some sort of calendar control without actually having to install/reference any add-ins in the vba.

I'm using Excel 2010 with vba.

JKwan
06-22-2011, 05:59 AM
Try this:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=543

Rayman
06-22-2011, 06:01 AM
I think that you have to install on your system the MSCOMCT2.OCX file.

This library add the control "Microsoft MonthView 6.0" and "Microsoft Date and Time Picker Control 6.0".

You can use these controls in a sheet and in a UserForm.

I attached here 2 file : mscomct2.ocx and mscomct2.inf ; for install them, right click on the .inf file and chose install.

In excel, add new control (additional registry controls).