How do I create a drop down cell with dates
 

I'd like to create a drop down cell in excel that shows a calender so I can
select specific dates. (that looks and feels like the Time & date properties
when you double click on the time on the bottom right hand corner of
screen).. is this even possible? If not, any suggestions to get around this?
Any help is greatly appreciated.

Hi Jagz

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

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jagz" wrote in message ...
I'd like to create a drop down cell in excel that shows a calender so I can
select specific dates. (that looks and feels like the Time & date properties
when you double click on the time on the bottom right hand corner of
screen).. is this even possible? If not, any suggestions to get around this?
Any help is greatly appreciated.

Ron,

Having used the VBA code from your link, how do I adapt it for specific
cells rather than a range?

"Ron de Bruin" wrote:

Hi Jagz

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

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jagz" wrote in message ...
I'd like to create a drop down cell in excel that shows a calender so I can
select specific dates. (that looks and feels like the Time & date properties
when you double click on the time on the bottom right hand corner of
screen).. is this even possible? If not, any suggestions to get around this?
Any help is greatly appreciated.

Hi

Use this

If Not Application.Intersect(Range("A1,C5,E1:E3,G20"), Target) Is Nothing Then



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Struggling of Essex" wrote in message
...
Ron,

Having used the VBA code from your link, how do I adapt it for specific
cells rather than a range?

"Ron de Bruin" wrote:

Hi Jagz

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

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jagz" wrote in message ...
I'd like to create a drop down cell in excel that shows a calender so I can
select specific dates. (that looks and feels like the Time & date properties
when you double click on the time on the bottom right hand corner of
screen).. is this even possible? If not, any suggestions to get around this?
Any help is greatly appreciated.