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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"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