Userform Find (VLOOKUP) function search string problem

Hi Guys,

I am hoping you can help me with this one. I am trying to build a search userform in excel that will allow the user to search using 1 of 3 possible search strings: Post Code, Check Number 1 and Check Number 2.

Now I am able to create a find function to work using a search that works using one search string, be it either Post Code, ChcNum1 or ChcNum2, however when I try to create one that will cancel out the other two based on the user input something goes awry in the code.

See the code below for help.

Please Login or Register  to view this content.

Please help, any input is greatly appreciated and you guys have been a great help in the past.

Thanks in advance!

Presumably you need to change the column, Columns(29). Include a Long Variable for the Column e.g. lCol and some means of choosing what to search by - a CombBox maybe & define lCol from this.