Adding a Drop-Down Calendar
 

Hi!

I would like to set certain cells in an Excel sheet so that they display a
date (not necessarliy today's date) from a drop-down calendar. This would be
like when you book an airplane ticket online, for example, and it asks you
for the departure and return date: you click on an arrow and a calendar pops
up; you click on the date you want, and it is then displayed in that field.
Can I do this with Excel 2003??? I serched long and hard through the HELP
stuff but couldn't find this anywhere, so THANK YOU in advance if you can
help me.

Cheers,

--
Paul H H

Adding a Drop-Down Calendar
 

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Paul H H" wrote in message
...
Hi!

I would like to set certain cells in an Excel sheet so that they display a
date (not necessarliy today's date) from a drop-down calendar. This would
be
like when you book an airplane ticket online, for example, and it asks you
for the departure and return date: you click on an arrow and a calendar
pops
up; you click on the date you want, and it is then displayed in that
field.
Can I do this with Excel 2003??? I serched long and hard through the HELP
stuff but couldn't find this anywhere, so THANK YOU in advance if you can
help me.

Cheers,

--
Paul H H

Adding a Drop-Down Calendar
 

Paul have a look here,

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Paul H H" wrote in message
...
Hi!

I would like to set certain cells in an Excel sheet so that they display a
date (not necessarliy today's date) from a drop-down calendar. This would
be
like when you book an airplane ticket online, for example, and it asks you
for the departure and return date: you click on an arrow and a calendar
pops
up; you click on the date you want, and it is then displayed in that
field.
Can I do this with Excel 2003??? I serched long and hard through the HELP
stuff but couldn't find this anywhere, so THANK YOU in advance if you can
help me.

Cheers,

--
Paul H H