Calendar popup

[JLees]

Is there a way to select dates from a calendar instead of typing them manually?

I would like to click on a cell, up pops a calendar, you select the date and it is entered into the cell.

Is anything like this possible?

 

[hatman]

This link should get you going:

http://www.ozgrid.com/VBA/excel-calendar-dates.htm

 

[Fergus]

or this one: http://www.fontstuff.com/vba/vbatut07.htm

 

[JLees]

Thanks guys, exactly what i'm after.

I'm following the second guide through, but I am stuck at the 'Add a Calendar Control to the UserForm' section.

I don't have Microsoft Access on this machine, and so don't have the mscal.ocx file. I followed the link, downloaded the file and put it in the correct place (System 32). This enabled me to select Calendar Control 10.0 as an Additional Control, but when I attempted to use the button it told me "Library not registered".

I was wondering if I am missing anymore files because I don't have Microsoft Access and if this calendar is still possible?

 

[Fergus]

After downloading the mscal.ocx file you still have to register it, - it's all in the instructions under the heading "Register the Control" then you must restart.