need to display the excel atcive control calendar to enter dates
 

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

need to display the excel atcive control calendar to enter dates
 

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

need to display the excel atcive control calendar to enter dates
 

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
|