Calendar Pop-up

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Mar 3, 2011

• #2

There's a lot of useful information here:

http://www.fontstuff.com/vba/vbatut07.htm

You could use the Worksheet_SelectionChange event procedure to pop up the calendar when particular cells are selected.

 

Upvote 0

M

mr.paul.c

New Member

Joined

Dec 10, 2010

Messages

20

• Mar 4, 2011

• #3

I found that link in another thread, what I don't quite understand is how to get the calendar to pop up if I click in a particular range of cells - which in my case would be any cell from F2 and H2 downwards (F&H1 are both column titles)

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Mar 4, 2011

• #4

Maybe you can adapt the macro here:

http://www.mrexcel.com/forum/showthread.php?t=461967

 

Upvote 0

M

mr.paul.c

New Member

Joined

Dec 10, 2010

Messages

20

• Mar 4, 2011

• #5

oops. I just realised I posted that reply in the wrong thread...my fault for having 2 different topics open in different tabs and replying to the wrong one

 

Upvote 0