Pop up calendar

[ccameron]

Hi Guys,
I am trying to add a calendar to a spreasheet, I want it to pop up when the cell is selected, pick a date and have the calendar disappear again. I can add a calendar, but it stays open on the sheet and I dont know how to get it to go away. Any idea's would be fantastic.
Thanks in advance for your help.

Excel 2007

Regards
ccameron

 

[VoG]

Take a look here http://www.fontstuff.com/vba/vbatut07.htm

 

[ccameron]

Thanks Vog,
I will have a look