How do I insert a dropdown calendar into a cell?

[Jeff Kass, San Diego, CA]

I am setting up a spreadsheet as a form. One of the cells will contain a
date the form was filled in. I would like to make it easy on the user by
making a small calendar popup when they click on the date cell. Then, the
only need to click on a date in the calendar and it will insert it. Airline
reservation sites do this a lot.

Anyone know how to do this in Excel 2007?

 

[FSt1]

hi
you might find some ideas here...
http://www.rondebruin.nl/calendar.htm

regards
FSt1

 

[Tyro]

not a good idea to broadcast who you are and where you are.

Tyro
"Jeff Kass, San Diego, CA" <Jeff Kass, San Diego,
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Tyro]

Yes. Excel 2007.

1) Office Button/Excel Options/Popular/Top options for working with Excel -
Check box Show Developer tab in Ribbon
2) Click Developer Tab
3) In Controls group click Insert
4) In Active X controls click on the bottom rightmost icon - More controls
5) Select Calendar Control 12.0 and click OK
6) Draw a box on the spreadsheet about 10 rows high and 5 columns wide
7) Right click on the calendar and select Properties
8) Change LinkedCell (blank) to be the cell you want the date to be in (A1,
G6 for example)
9) Click Design Mode in Controls group to exit Design Mode and have the
calendar work
10) Click on a date in the calendar and you should see that date in the cell
you entered in step 8
11) To make further changes click Developer tab, Controls group, Design
Mode, Click the calendar and change whatever

Tyro

"Jeff Kass, San Diego, CA" <Jeff Kass, San Diego,
(e-mail address removed)> wrote in message
news:[email protected]...

 

[dstone]

Almost worked, one question please


I'm read you explanation and it worked great with one exception. I have the calendar on the page, and it is linked but how do I make a drop down menu in each cell that makes the calendar come up so I can choose the date? This would be SO great if I could get it to work.
Much Thanks!

Yes. Excel 2007.

1) Office Button/Excel Options/Popular/Top options for working with Excel -
Check box Show Developer tab in Ribbon
2) Click Developer Tab
3) In Controls group click Insert
4) In Active X controls click on the bottom rightmost icon - More controls
5) Select Calendar Control 12.0 and click OK
6) Draw a box on the spreadsheet about 10 rows high and 5 columns wide
7) Right click on the calendar and select Properties
8) Change LinkedCell (blank) to be the cell you want the date to be in (A1,
G6 for example)
9) Click Design Mode in Controls group to exit Design Mode and have the
calendar work
10) Click on a date in the calendar and you should see that date in the cell
you entered in step 8
11) To make further changes click Developer tab, Controls group, Design
Mode, Click the calendar and change whatever

Tyro



"Jeff Kass, San Diego, CA" (e-mail address removed)> wrote in message
news:[email protected]...
>I am setting up a spreadsheet as a form. One of the cells will contain a
> date the form was filled in. I would like to make it easy on the user by
> making a small calendar popup when they click on the date cell. Then, the
> only need to click on a date in the calendar and it will insert it.
> Airline
> reservation sites do this a lot.
>
> Anyone know how to do this in Excel 2007?

 

[Bruce Altenburger]

I guess this doesn't work for Excel 2003? I guess this sounds stupid but I can not find the "Office Button" in step one. I am hoping it is b/c it doesn't exist with 2003 and that I am not being a total idiot.

I had used another method where you download the add-in from Ron de Bruin, and it works on the spreadsheet I created, however, when I sent it to someone else the calendar pulldown does NOT appear. I presume this is b/c they'd have to download the add-in too?

Thanks for your help !!!

Bruce

 

[dstone]

I don't know about Excel 2003. However, the OFFICE button is the circle at the top left with the office design in it. click on that. then at the bottom of the screen that comes up, you will see the Excel Options.

Hope this helps.

 

[David Biddulph]

You're right. There isn't an Office button in 2003. It was introduced at
2007.

And in reply to the second part of your message, to use an add-in you do
need to have the add-in installed and enabled.

It's always wise to quote in your message the relevant parts of the message
to which you are replying, as otherwise (for example) we don't know what you
mean by "step one".

For the benefit of anyone else who is trying to decipher what you may have
meant, looking at the headers of your message I see that the message to
which you replied, but from which you snipped the entire content, was
which reads as follows:

"Yes. Excel 2007.

1) Office Button/Excel Options/Popular/Top options for working with Excel -
Check box Show Developer tab in Ribbon
2) Click Developer Tab
3) In Controls group click Insert
4) In Active X controls click on the bottom rightmost icon - More controls
5) Select Calendar Control 12.0 and click OK
6) Draw a box on the spreadsheet about 10 rows high and 5 columns wide
7) Right click on the calendar and select Properties
8) Change LinkedCell (blank) to be the cell you want the date to be in (A1,
G6 for example)
9) Click Design Mode in Controls group to exit Design Mode and have the
calendar work
10) Click on a date in the calendar and you should see that date in the cell
you entered in step 8
11) To make further changes click Developer tab, Controls group, Design
Mode, Click the calendar and change whatever

Tyro

"Jeff Kass, San Diego, CA" <Jeff Kass, San Diego,
(e-mail address removed)> wrote in message

 

[George1960]

Hi in the above discussion about inserting a calendar in to an Excel worksheet, I belive the second person who inquired as to how to do this wanted to do this in consecuative cells in a column.
I am trying to put a seperate drop down calendar in every cell in a column, so as to reference a different date for each rows data.

Thanks
George