Insert calendar slector

[bjbboats]

hi all

is there a way to be able to click on a cell and a calendar selector pops up to input a date into that cell?

thanks

[berlan]

Sure, but that would involve VBA...

[bjbboats]

is that difficult to do?

[berlan]

See if this thread with a UserForm Calendar made by Leith Ross would be of help, http://www.excelforum.com/excel-prog...-calendar.html

You could add functionality to activate the calendar when double clicking on a (specific) cell.

[bjbboats]

Looks perfect thanks. Any idea how to add that kind of functionality?

[bjbboats]

Do you know if there's a tidier way of including the calendar. I have a list of campaigns and a launch and end date column which i'd like to use for the calendar pop up

i have attached a basic version but it is a long list of campaigns so if it's possible to set it up for clicking on the cell that would be perfect!

Thanks