Ron de Bruin provides some sample code at his site:

http://www.rondebruin.nl/calendar.htm

For the lookup, look at Data=Validation and select the list option. For
more information, you can look at Debar Dalgleish's site:

http://www.contextures.com/tiptech.html

--
Regards,
Tom Ogilvy



"Deepa7476" wrote:


hi
i what to know

- "how to insert the calender control in to a cell?"so that i will
avoid the hassle of manually entering the date
- Is it possible to extend this functionality to the entire column?
- Is it possible to create a look-up (with a drop box having list of
values)? to an individual cell.

thnkx frinds


--
Deepa7476
------------------------------------------------------------------------
Deepa7476's Profile: http://www.excelforum.com/member.php...o&userid=33106
View this thread: http://www.excelforum.com/showthread...hreadid=529141