need to display the excel atcive control calendar to enter dates

[Rich analyst]

Hi
who could explain to me ( in detailed steps) , how to have the active
control calendar displayed in my worksheet, each time, my user will click on
each cell where they need to input a date?
I found the active control caledar in the insert menu in the design mode,
but I have no idea how to link the automatic display of this calendar with
the right click on the specific cells where a date need to be entered.
As well, once the calendar is displayed, how do I transfer the date choosen
by the user to the specific cell respecting the desired format DD/MM/YY ( and
of course have the calendar dissapearing once the choosen date is selected
and in place in the desired cell ....I guess with a "OK" button on the
calendar?)

if someone could help me on this it would be great (step by step process) ,
it would give the professional touch im looking for, in my Excel data entry
template.

thanks

Rich

 

[Ron de Bruin]

See this page Rich
http://www.rondebruin.nl/calendar.htm

 

[Niek Otten]

Hi Rich,

Look here:

http://www.rondebruin.nl/calendar.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi
| who could explain to me ( in detailed steps) , how to have the active
| control calendar displayed in my worksheet, each time, my user will click on
| each cell where they need to input a date?
| I found the active control caledar in the insert menu in the design mode,
| but I have no idea how to link the automatic display of this calendar with
| the right click on the specific cells where a date need to be entered.
| As well, once the calendar is displayed, how do I transfer the date choosen
| by the user to the specific cell respecting the desired format DD/MM/YY ( and
| of course have the calendar dissapearing once the choosen date is selected
| and in place in the desired cell ....I guess with a "OK" button on the
| calendar?)
|
| if someone could help me on this it would be great (step by step process) ,
| it would give the professional touch im looking for, in my Excel data entry
| template.
|
| thanks
|
| Rich
|