Calendar not working in Excel 2010 VBA.

**AnkitTandon** · 04-20-2011, 01:39 AM

Hi all,

We have been working on Excel 2003 and Calendar Date functionality is working fine. But in Excel 2010, the same code is throwing a compilation error that Object or module not defined.

----------------------

Please Login or Register  to view this content.

----------------------

I know that the libraries are different but even if we click on the "ok" in that error, rest of the functionalities are working fine except the calendar.

Thanks in advance

Regards,
Ankit

**Cutter** · 04-20-2011, 10:48 AM

Hi AnkitTandon and welcome to the forum.

I'm not a VBA expert so I can't give you a solution but I've seen this problem raised a few times.

From Microsoft: http://technet.microsoft.com/en-us/l.../cc179167.aspx

Calendar control
Calendar control (mscal.ocx) was a Microsoft Access feature that could be used in Access worksheets. Calendar control is removed in Access 2010 and is not usable for Excel 2010. Instead, users can use Date Picker or their own custom calendar controls.