ENTER A DATE USING CALENDAR CONTROL

[Asoka Walpitagama - Brandix College IT]

I need toa insert a date to a Cell ( eg B2 ) using calender control ( By
double clicking a date in the calender )
I know how to get calender control displayed on the sheet by using Developer
-- > Insert --> Calender Control
need to know the rest.

Thanks

Asoka

 

[FSt1]

hi
ron de bruin has step by step instructions for this. see his site....
http://www.rondebruin.nl/calendar.htm

Regards
FSt1

 

[Joel]

You need to set the Linked Cell property of the calendar. do the following
from worksheet menu

1) View - Toolbars - Control toolbox.
2) On the toolbar press the triangle which is a toggle button which
enters/exits design mode. You should see the sizing dots on the calendar
controll when in design mode
3) With the sizing button visible on the calendar control press the
Properties ICON on the toolbar(the one with the hand). The property window
for the calendar control should be visible.
4) In the LinkedCell prperty enter a cell location like sheet1!I1
5) Exit design mode by pressingTriangle on the toolbar.
6) Now when ever you select a date on the calendar the linked cell value
will change.