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

Signature
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
> Had some nice code off a magazine to make the calendar
>
[quoted text clipped - 21 lines]
>
> thanks
Dewi... - 26 Jun 2007 18:33 GMT
> Hi Dewi
>
[quoted text clipped - 31 lines]
>
> - Show quoted text -
many thanks, will work through it later.
Ben - 17 Sep 2007 20:04 GMT
Ron,
The link below worked well. I have an additional question. How do I tell
Excel to display the calendar when a particular cell is clicked? It is
almost like data validation... I don't want the user to click a button, would
just like the calendar to be displayed on cells that require dates.
Thanks - Ben
> Hi Dewi
>
[quoted text clipped - 26 lines]
> >
> > thanks
Ron de Bruin - 17 Sep 2007 22:07 GMT
Hi Ben
The code on my site is doing what you want
If you use the userform example you can also use the selection change event to
open the userform when you click on a cell.
See de code on my page how I run code when I select a cell in a range

Signature
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
> Ron,
>
[quoted text clipped - 35 lines]
>> >
>> > thanks