Callendar to date?
 

I'll admit this is not drastically important, but would be nice....

Is there a way when you click on an icon or a cell or whatnot... it
pops up a callendar.... you select the date.... and then it puts in
the date you slected...

example... on the callendar you select July 3

So in the cell it reads: 07/03/2006

Is that possible? or should I go back to bed and keep dreaming? =)


--
rjmckay
------------------------------------------------------------------------
rjmckay's Profile: http://www.excelforum.com/member.php...o&userid=16880
View this thread: http://www.excelforum.com/showthread...hreadid=550213

Callendar to date?
 

hi,
you are refering to a calendar control. there are a lot of them. do a google
on "calendar control excel". pick from list. i got 8,560,000 hits.

regards
FSt1

"rjmckay" wrote:


I'll admit this is not drastically important, but would be nice....

Is there a way when you click on an icon or a cell or whatnot... it
pops up a callendar.... you select the date.... and then it puts in
the date you slected...

example... on the callendar you select July 3

So in the cell it reads: 07/03/2006

Is that possible? or should I go back to bed and keep dreaming? =)


--
rjmckay
------------------------------------------------------------------------
rjmckay's Profile: http://www.excelforum.com/member.php...o&userid=16880
View this thread: http://www.excelforum.com/showthread...hreadid=550213

Callendar to date?
 

It's certainly possible, it takes some work though

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

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"rjmckay" wrote in
message ...

I'll admit this is not drastically important, but would be nice....

Is there a way when you click on an icon or a cell or whatnot... it
pops up a callendar.... you select the date.... and then it puts in
the date you slected...

example... on the callendar you select July 3

So in the cell it reads: 07/03/2006

Is that possible? or should I go back to bed and keep dreaming? =)


--
rjmckay
------------------------------------------------------------------------
rjmckay's Profile:
http://www.excelforum.com/member.php...o&userid=16880
View this thread: http://www.excelforum.com/showthread...hreadid=550213