Using a TextBox in a Userform
 

How do I use a textbox (or similar tool) in a userform to display the results
of a lookup based on another input box in the same userform. In other words,
I want to enter a number into field one and have field two show the results
of a lookup all before pressing the OK button.
--
RWL

Using a TextBox in a Userform
 

Private Sub TextBox1_AfterUpdate()
With Me

.TextBox2.Text = Application.VLookup(.TextBox1.Text,
Worksheets(1).Columns("A:B"), 2, False)
End With
End Sub



--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"bobl" wrote in message
...
How do I use a textbox (or similar tool) in a userform to display the
results
of a lookup based on another input box in the same userform. In other
words,
I want to enter a number into field one and have field two show the
results
of a lookup all before pressing the OK button.
--
RWL