Forum Discussion
Solved
Compile error: Method or data member not found
I'm using three List Boxes on one sheet (the Font Book tab), where clicking one deselects the other two. The worksheet functions as expected, but on opening the workbook, I receive the "Compile error...
You had the code in a code module and a worksheet code module. If the code is in the worksheet module you can use syntax like:
Me.ListBox2.Value = ""
If you use a code module you have to specify the worksheet:
Sheets("Font Book").ListBox2.Value = ""It looks like your code was duplicative. I removed the code module stuff and now it works fine (See attached)
Excellent - thank you!
You're quite welcome. Glad you have it working. Please feel free to post back to the community in the future if you have any other inquiries.