Calendar code??

[Laura Marie]

Hi,
I would like to insert a calendar into a cell that will "pop out" like when booking an airline, and then you would choose your date. Is there such a thing in Excel?

[Hurricanefly]

Well you could type in cell A1 1/1/13 then copy down uuntil you get to 31/12/13. Then use data validation to create a list of the year dates. You could hide the column or put the dates in a different sheet. The other way is using a form in VBA.

[Hurricanefly]

The other way.

Step 1
Click the "Office" button and select the "Excel Options" option from the drop-down menu that appears.
Step 2
Click the "Popular" tab in the "Options" menu and place a check mark next to the "Show Developer Tab in the Ribbon" option. Click "OK" to save the changes.
Step 3
Click the "Developer" tab, followed by the "Insert" menu. Select the "More Controls" button in the drop-down menu that appears.
Step 4
Highlight the "Microsoft Date and Time Picker Control" option, then click "OK."
Step 5
Click on the upper left corner of the cell to which you want to add the calendar and drag your mouse pointer to the cell's bottom-right corner. This will draw a rectangle around the cell.
Step 6
Release your mouse button to insert the calendar into the cell. Whenever you click on the cell, the calendar drop-down menu will appear.

[Laura Marie]

Thanks. When I insert that control, it just shows the date in a drop down. If I click on the cell, it just brings up the DBA form.

[Laura Marie]

Oh! I got it!!!
Thanks so much!!!

[Hurricanefly]

No probs, glad to be of help