VBA code to popup a calender

**mlafrance** · 01-21-2014, 05:54 PM

Hi there,
I'm using Excel 2010 and have a form that I'd like a calendar to popup if the content of the cell is a date. I get a runtime error 424; object required. Below is the code that I used in Excel 2003. The highlighted row is where the error is thrown.

Please Login or Register  to view this content.

Thanks.
Mike

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags; I have added them for you because you are still new. --6StringJazzer

**6StringJazzer** · 01-21-2014, 06:24 PM

What is Calendar1? If you built this in Excel 2003 but are now using a different version I am guessing it is a DTPicker or something similar that is not built in; you have to explicitly import it into Excel.

**mlafrance** · 01-21-2014, 07:05 PM

Yes, I had to import the MS MonthPicker activex control to get the Calendar function. When I changed "Calendar1" to "MonthView1" the error went away.
Thanks for triggering that resolution, Jeff. I wouldn't have thought of it. This problem is resolved.

Mike