Using a Pop Up Calendar

[EdWoods]

Hi

I'm wondering if there's a way to get a calendar to pop-up after being initiated by (say) a double click in a cell and then selecting the date from the calendar. The selected date is then pasted into the cell.

I can use the Double Click function, but not sure if you can get it to call up a calendar.

Cheers, Paul

[alansidman]

Attached is a spreadsheet that has a calendar built into it. you could modify this to have the calendar appear with a double click.

[EdWoods]

Works perfectly. Thanks heaps.

[torachan]

Alternative - far less code and configurable - double click column A or B - set this to where you want,

[EdWoods]

This does it too. Thanks

[EdWoods]

Thanks to both. Cheers