| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box 2 based on text box 1
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
text box 2 based on text box 1
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| How to auto-fill text based on text in another cell | Excel Discussion (Misc queries) | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
| Deleting Rows based on text in cell & formatting cell based on text in column beside it | Excel Programming | |||
Hybrid Mode
