calendar pop up

**stevesunfold** · 10-06-2008, 08:17 AM

Hi Guys
Borowed This Code From The Site And Indeed It Comes In Very Handy

Please Login or Register  to view this content.

What I Personally Want It To Do Though Is When A Date Is Selected It Will Go Back To The Spreadsheet Itself Without Having To Click The Sheet Myself

Is This Possible?

THANKS

**TheRetroChief** · 10-06-2008, 09:12 AM

Indeed it is....this is what i use....

Please Login or Register  to view this content.

With Range("x:y") representing the range of cells you want the calendar to be active in!!!

Hope that works for you!

Ali Mac

**stevesunfold** · 10-06-2008, 09:42 AM

hi retro
looks promising but when i put d4 into the range it comes up with run time error

**TheRetroChief** · 10-06-2008, 09:53 AM

If you only want it in one cell try Range("d4:d4").
I use it for around 100 odd cells. I don't see why range won't work for just one cell if you put it in like that. If you wanted to expand the number of cells it works on (this was my problem a while ago) in the future then range is the way to go. eg. in cells d4, d5 and d6 then Range("d4:d6") would make it pop up there. So try d4:d4.

**stevesunfold** · 10-06-2008, 09:59 AM

hi retro
appreciate you replies but still the same

**TheRetroChief** · 10-06-2008, 10:12 AM

Apologies if i'm insulting your intelligence, but i'm relatively new to this and don't know what is standard knowledge/practice.
Have you enable the calendar control thingy:
Insert > Object... > Calendar Control ???
That's what i had to do first time around.
Oh, and make sure SelectionChange is in the second drop-down on the VBA editing page above and to the right of your code.
Other than that then I'm afraid i know nothing.

Try posting what you have on the forum so i can see.....not that i really know what i'm looking at!!!

**stevesunfold** · 10-06-2008, 10:18 AM

retro

i am so sorry my friend and thanks for your patience.

i was trying your code in a new spreadsheet and hadnt enabled the calendar control ( feel stupid now )

the last thing i would ask you kindly to help with is
i want this only to happen in cells d4 and cells d14 so its no a range so to speak just the two selected cells

once again thanks so much for your help