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

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