I am developing a macro that needs to find whatever text is in cell A33 of
sheet1 in a range on sheet2. Cell A33 text changes depending on the
selection made from a userform.

I have figured out a very, very long winded IF, ELSE IF code that uses all
possible values that could be in cell A33 but am hoping there is a simpler
way to do it.

I have trawled through Excel and Excel VBA help and cant find what I need.