Method or data member not found

Hello everyone!

I am using some ActiveX ComboBox on my sheets to filter some information. It was working fine, but out of the blue an error occurred and I received the bellow message:

Compile error: Method or data member not found


And then my ComboBoxes aren't recognized anymore...

The code that I used was this:

Please Login or Register  to view this content.

Any idea why this error occurred? =\

Which line of code causes the error? When this compiler error occurs, it will highlight in blue the exact thing that it can't find.

This suggests that Sheet2 does not actually have a combobox named ComboBox1 (or whatever line is causing the error). (I didn't have a Sheet2 so I used Sheet14, which has no ComboBoxes.)

methodnotfound.JPG

Also, you only showed a few lines of code so I don't want to make too big a deal out of this BUT:

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I have edited your post to add code tags because you only have 11 posts.

Make sure you use ActiveX controls.

I only see pictures

Strange ??? - Have you copied and pasted the page as the comboboxes have retained their names but appear to be images (pictures) ?????
I have just deleted then re-inserted and they work OK (note each sheet will contain a name ComboBox1 - the sheet prefix will determine which is referenced).
As a cautionary note, always have your control totally contained within cell boundaries - it prevents them losing their location and wandering randomly around the sheet.

@JEC - are you sure ?

You can not use the .List property. Use this instead

Originally Posted by BiaMidori

...my Comboboxes transformed into pictures and lost their ActiveX property.

I have had this happen once or twice. I assumed it was a random file corruption and never figured out the root cause.