Compile Error : Method or Data member not found (Excel 2013)

**psingh409** · 08-04-2015, 12:28 PM

Hi ,

I have an excel macro written in Excel 2010 which uses a form (Calendar) to seek date input from user.

Recently one of the user tried using the same excel macro on his machine with excel 2013 and is receiving the error which says Compile Error : Method or Data member not found.

I don't have a way to replicate the error locally without installing 2013 and debugging the same.

Any idea what could be the problem ?

Thanks

**6StringJazzer** · 08-04-2015, 01:27 PM

It is very likely that 2010 vs. 2013 is not the issue but rather what libraries are available and installed to VBA. The calendar is probably non-standard (do you mean DTPicker?). Please attach your Excel file and describe how to reproduce the error. At a minimum, show the code in the module with the error and indicate what line of code is highlighted when the error occurs.

**psingh409** · 08-06-2015, 11:34 AM

Thanks Jeff .

I'm using the form Control for Calendar.

Please Login or Register  to view this content.

User clicks on a button which adds a row where one of the column has a date picker

'*************** distribution - Show date picker on click of date cell Starts ***************

Please Login or Register  to view this content.

'*************** distribution - Show date picker on click of date cell ends *****************
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 this time because you are a new member. --6StringJazzer

User sees a break on when trying to access this mycalendar. I made sure Tools --> References user has all the library being referenced