| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Link textbox2 to textbox1 via a vlookup
Hi
I am looking to post a number in textbox1 and have this formula in textbox 2 =vlookup(textbox1, database,2,0). Could somebody please help thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link textbox2 to textbox1 via a vlookup
Are you asking for the result of the formula to appear in textbox 2?
Try this..... textbox2.Value = Application.WorksheetFunction.VLookup(textbox1.Val ue, database, 2, 0) -- Regards, Nigel wrote in message ups.com... Hi I am looking to post a number in textbox1 and have this formula in textbox 2 =vlookup(textbox1, database,2,0). Could somebody please help thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TextBox1 to Label4 | Excel Discussion (Misc queries) | |||
| When data in TextBox2 matches data in TextBox1 | Excel Programming | |||
| TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value) | Excel Programming | |||
| TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value) | Excel Programming | |||
| TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value) | Excel Programming | |||
Linear Mode
