Callendar to date?

[rjmckay]

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? =)

[FSt1]

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
>
>

[Peo Sjoblom]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>