Forum Discussion
Compile error: Method or data member not found
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)
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.