change textbox1's property 'Linked Cell' to, say J1 (or any available
cell on the sheet).
in J2 put a vlookup formula which uses J1 to look up into the area
A1:B10 - this should return the value you are after.
change textbox2's property 'Linked Cell' to J2 or whereever you have
located the vlookup formula.

J



On 6 Jun, 15:48, Shawn wrote:
I have a text box 1 whose value is most likely equal to a value in range
Sheet1.Range ("A1:A10").

If the value in text box 1 does equal a value in sheet1.Range("A1:A10") I
want Text box 2's value, upon tabing into it to equal the value of the
adjacent cell in sheet1.range "B1:B10".

--
Thanks
Shawn