Hi Rich,

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rich analyst" <Rich wrote in message
...
| 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
|