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)
 

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Two types of textbox input 1
using VLOOKUP in a text box 2
Textbox1.Value Question 2
Populate TextBox with Change Event 5
Arbitrary data to Textboxes in UserForm 4
Userform textbox string to header causes unwanted double spacing 4
Userform Textbox 3

Back
Top