Need to Search via Userform based on Selection

[mfjanoo]

HI

I have this spreadsheet that I would like to search on 4 fields based on selection using a Userform. The first two options work fine. I am having problem searching on ALB Tag and Monitor ALB Tag.

I have attached my spreadsheet

[mike7952]

Problem is the values your adding to your combobox1 don't match the Select case section in your search button procedure "CommandButton5_Click".


you have

Please Login or Register  to view this content.

but have this in your CommandButton5_Click. So it'll doesn't find the match.

Please Login or Register  to view this content.

Replace the section of code in your UserForm_Initialize and replace with below.

Please Login or Register  to view this content.

[mfjanoo]

Hi Mike

THanks a million
Works brilliantly
Thanks

[mike7952]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.