Insert a calendar/data validation into a cell

[Lizzi]

Hi,

after several hours of "googling" i'm still not able to find anything to help me, i'm trying to add/make a calendar into a cell, so when they click on the cell the calendar pops up and they can select a date. I have tried unsucessfully several times to install the microsoft date and time picker but it's just not working for me....dont know why

im using windows 7, excel 2010. does anyone have any other ways i can do this please?

thanx in advance for your answers.

 

[Nalani]

See if this link is what you are after.

Use the Calendar control to fill in dates

Ron uses the Range of A1:A20, but he explains how to adjust the code as you read further down.

 

[Lizzi]

thanx for the reply, plse figure my ignorance but is says on that link you gave me
"Excel 2007-2010
On the Developer tab use Insert > ActiveX Controls….More controls.
Select the control in the list and press OK
Click on a cell on your worksheet.
Press the "Design Mode" button next to the "Insert button" to turn of Design Mode."

What "control" should i be selecting?

 

[Nalani]

It would be the Calendar Control.

Ron also explains this a little further down:

Excel 97-2010
It is possible you don't see it in the list, because it is installed with Access.
So if you don't have that program installed you possible don't have the control.
Note: The control is removed from Office 2010 so you must register the 2007 version.
You can download the control if you don't have it (See link on the bottom of this page).

 

[Lizzi]

im sorry i should have been more descriptive, i read further down, went to the suggested website, downloaded the addin.....and nothing worked. I have downloaded numerous things and nothing seems to work, it's so frustrating. The link Ron suggests is an addin but when i went to save it to a location, it only saves in excel 2003.....whats the point in that when im using 2010.