Find a value in column A and return the text in column B

[Arcadian]

Hi all,

I think this isn't too dificult, but I can't figure it out.

On worksheet 1 there are these values:

Column A Column B
A01 text01
A02 text02
A03 text03
A04 text04
A05 text05
A06 text06
A07 text07
A08 text08
A09 text09
A10 text10

On worksheet 2 I have the same values as worksheet 1 column A and depending on which cell is active a VBA code returns a value, for instance A03.

I need a VBA code that looks for the matching value (A03) in column A on worksheet 1 and return the corresponding value (text03) in column B so I can use it in a userform.

Thanks in advance.
I need a VBA code that

 

[Fluff]

Can you post your existing code.