A Andy T Apr 2, 2004 #1 Is there a way to get a calendar pop up when left clicking a cell in Excel 2002?
C Chip Pearson Apr 2, 2004 #2 Andy, The short answer is no, you can't do this. The longer answer is that yes, you could do this. Create a userform and put a calendar control on that form. Then, use the BeforeRightClick event procedure for that worksheet to display the form. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Andy, The short answer is no, you can't do this. The longer answer is that yes, you could do this. Create a userform and put a calendar control on that form. Then, use the BeforeRightClick event procedure for that worksheet to display the form. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
B Bob Phillips Apr 2, 2004 #4 Andy, Take a look here http://www.fontstuff.com/vba/vbatut07.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Andy, Take a look here http://www.fontstuff.com/vba/vbatut07.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
