Link textbox2 to textbox1 via a vlookup

  • Thread starter Thread starter paulwes
  • Start date Start date
P

paulwes

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
 
Are you asking for the result of the formula to appear in textbox 2?

Try this.....

textbox2.Value = Application.WorksheetFunction.VLookup(textbox1.Value,
database, 2, 0)
 
Back
Top