How to use Microsoft Calendar Control 9.0 on a Userform

[Anupam Sharma]

I would like to create several date fields on a Userform where a user can
select the dates from a calendar (preferably a "fly out type of calendar").
I have not been able to find any documentation on this.

Can someone provide pointers, or a good link to figure this out?

 

[John Wilson]

Anupam,

Take a look here for some instructions.
It's for the Calendar 8.0 but it's basically the same as 9.0

http://www.microsoft.com/exceldev/articles/CalExcel.htm

John

 

[Orlando Magalhães Filho]

Hi Anupam Sharma,

If you want a calendar with some others features, look for "Excel popup
Calendar" at this site:
http://cpap.com.br/orlando
and look for "Text Box to input dates in VBA code" too.

About how to use Microsoft Calendar Control 9.0 do this:
- Insert an Userform;
- Right click Toolbox bar
- Click on Additional Control command.
- Select Calendar Control 9.0 if it isn't select yet;
- Ok
- Drag it icon over the userform.
- Press F1 to more help about its methods, properties and events.


HTH

 

[Android]

Hi John,

Thanks for this link. Appears quite comprehensive. Going thru it now.

Anupam.

 

[Android]

Hi Orlando,

Thanks for the pointer and for the link. Will check it out.

Anupam.