Calendars

[Worzel Gummidge]

I am looking at inserting a calendar within my spreadsheet. Nonetheless, I
want the calendar to pop up WHEN I click within any cells within the range
H6:H900.

I have looked at sites such as http://www.fontstuff.com/vba/vbatut07.htm and
am ok with setting up the calendar. Nonetheless, how do I set it up so that
the calendar automatically pops up when I click in any cell within the range
H6:H900?

Thanks

 

[Gord Dibben]

Worzel

See Ron de Bruin's site for code.

Adjust the range to H6:H900

http://www.rondebruin.nl/calendar.htm

I am looking at inserting a calendar within my spreadsheet. Nonetheless, I
want the calendar to pop up WHEN I click within any cells within the range
H6:H900.

I have looked at sites such as http://www.fontstuff.com/vba/vbatut07.htm and
am ok with setting up the calendar. Nonetheless, how do I set it up so that
the calendar automatically pops up when I click in any cell within the range
H6:H900?

Thanks

Gord Dibben MS Excel MVP