text box 2 based on text box 1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA help: Text file formatting 19
Arrays and scattered cell values or another way? 16
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Set non-continuous PrintArea via Function / Name 0
VBA code for pasting links -- modifying RDB code for summary workbook 10
Using Collection to also capture range adjacent 10
Display Sheet1: (A1:A10) value in Sheet2: (B1) 11
If value occurs more than once then delete all of them 8

Back
Top