Several years ago i was able to have a calendar appear when I clicked on a cell - we used this for data entry people to choose a date instead of typing one - i have no idea how we did this; I had found the code on a web site and then I'm not sure how I put in in the cell (it was like a drop down menu) any ideas?

It's the calendar control. See Ron's site
http://www.rondebruin.nl/calendar.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Della" wrote in message
...
Several years ago i was able to have a calendar appear when I clicked on a
cell - we used this for data entry people to choose a date instead of typing
one - i have no idea how we did this; I had found the code on a web site and
then I'm not sure how I put in in the cell (it was like a drop down menu)
any ideas?