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
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