Adding Wildcard to VBA Search Criteria to Produce a Message Box

Hi....I have a vba code that is using the values in 3 cells (drop down combo boxes) to bring the user to specific rows and columns on a specific sheet in my workbook (partial of the code is below). This is working beautifully. My problem is now if the value of "list3" equals "Other", regardless of the values in "list1" or "list2", I need a message box to pop up instead of bringing the user to another sheet. I can't seem to get this to work. There are over 150 different combinations of choices available in my list already so I'd prefer to use wildcards (*) for the "list1" and "list2" values and only have this line of code in once if possible. But I can add code in for each combination if that is what I need to do. I can't seem to get the write syntax to make it work. Any idea of how to do this and where to put the code? Thanks

Please Login or Register  to view this content.

Thank you! That worked. I was hung up on the idea of looking at all 3 lists.

Have a good day.
Kat