Hi,
Could someone please tell me how to use a calendar control in a worksheet.
For example, Cell A1 is a required date field. Is it possible to have a
calendar control pop up when you click on cell A1, select a date and have
the date selected entered in cell A1.
Is this possible.
Any help please
Regards
John
John - 12 Jun 2007 21:03 GMT
Sorry,
Forgot to mention I use Excel 2003
Regards
John
> Hi,
> Could someone please tell me how to use a calendar control in a worksheet.
[quoted text clipped - 9 lines]
>
> John
bj - 12 Jun 2007 22:40 GMT
sounds like the macro in
http://www.rondebruin.nl/calendar.htm
will do for you
> Sorry,
> Forgot to mention I use Excel 2003
[quoted text clipped - 16 lines]
> >
> > John
John - 13 Jun 2007 08:36 GMT
Many Thanks,
Just the ticket.
Regards
John
> sounds like the macro in
> http://www.rondebruin.nl/calendar.htm
[quoted text clipped - 22 lines]
>> >
>> > John