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?

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

"Anupam Sharma" wrote in message
.. .
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?

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

---

(So that you get best and rapid solution and all may benefit from the
discussion, please reply within the newsgroup, not in email)


"Anupam Sharma" escreveu na mensagem
.. .
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?

Hi John,

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

Anupam.
"John Wilson" wrote in message
...
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

"Anupam Sharma" wrote in message
.. .
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?

Hi Orlando,

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

Anupam.
"Orlando Magalhães Filho" wrote in message
...
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

---

(So that you get best and rapid solution and all may benefit from the
discussion, please reply within the newsgroup, not in email)


"Anupam Sharma" escreveu na mensagem
.. .
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?