date picker

Todd Bardoni

Well-known Member

Joined

Aug 29, 2002

Messages

3,042

• Aug 14, 2003

• #2

You could probably create one using some code and a userform or on a separate worksheet. But as far as something like that already existing in Excel, no.

 

Upvote 0

P

PaddyD

MrExcel MVP

Joined

May 1, 2002

Messages

14,234

• Aug 14, 2003

• #3

try this:

1) right click on te tool bar, select control tool box tool bar
2) click on more controls
3) select calendar control
4) stick one on the worksheet - size as needed
5) right click on the calendar object, select properties
5) scroll down to the Linked Cell option - put in something like A1
6) exit design mode on the control toolbar

...when you select a date from the calendar, it'll show up in a1.

 

Upvote 0

Todd Bardoni

Well-known Member

Joined

Aug 29, 2002

Messages

3,042

• Aug 14, 2003

• #4

Wow! That's cool!

 

Upvote 0

M

mgana

Board Regular

Joined

Jul 18, 2003

Messages

61

• Aug 14, 2003

• #5

Is there a way to make it work for a range of cells? And make the control appear only when one of those cells is selected?

 

Upvote 0

M

mikeprice53

Active Member

Joined

Jan 21, 2003

Messages

297

• Aug 14, 2003

• #6

This may seem really silly and such a trivial question but my inserted controls dont let me do anything with them ? Any reason or settings this could be please help...

 

Upvote 0

M

mgana

Board Regular

Joined

Jul 18, 2003

Messages

61

• Aug 14, 2003

• #7

Mike, exit the design mode. (Look for a "Design mode" button on the control toolbar)

 

Upvote 0

M

mikeprice53

Active Member

Joined

Jan 21, 2003

Messages

297

• Aug 14, 2003

• #8

ROFL !

I think it must be teh 2 pints i had last night ! :P I knew it would be so simple ... thank you very much indeed sire for my kick in a$$ I needed it

Mike

 

Upvote 0

M

mikeprice53

Active Member

Joined

Jan 21, 2003

Messages

297

• Aug 14, 2003

• #9

Last Question on these things...

the cell you pick for it to state the date you are currently on in the calendar ( A1 for instance ) does not seem to be an actual anything so to speak !

i was trying to do a vlookup and using the A1 as a lookup cell so if you had cell A1 saying the date was 14/08/2003 and wanted to vlookup if there was a name next to it ( for a holiday sheet for instance ) it will not lookup the cell in question as it dosnt accept what is in A1 as any sort of reference ...

I am really puzzeld why if anyone could explain this i would be very grateful...

thx

 

Upvote 0

alcorjr

Active Member

Joined

Dec 29, 2002

Messages

416

• Aug 14, 2003

• #10

Re: date picker- where?, where?

Paddy, thanks for your suggestion. I'm eager to try it, but:
which toolbar are we talking about, the one on the sheet proper or the one on the userform?

what is the exact name of the additional "calendar control" you mention, cause I can't find it.


Thanks

 

Upvote 0