Hi Everyone,

I am trying to get a cells value to return to a textbox in a userform

example

Textbox1 contains "Bob"

I want it to search worksheet 3 and column A

If "Bob" is found lets say in A7 then I want it to return the value from B7 to Textbox2

any Ideas?

many thanks in advance