Automatic Vlookups in Forms

  • Thread starter Thread starter savv32
  • Start date Start date
S

savv32

Hi, i need to know if there is a way to have an excel form
perform a lookup within the form. To better describe this,
i currently have a form set up that has a box where i enter
a job number, i would like for this number to bring up the
corresponding job name in some area next to the job number
so that the person entering the data can make sure he/she
has the right job. Is this possible and if so how can i get
my form to perform this function...

Thanks
Scott
 
You can use the Exit or Change events of the text box you are enterin
the data in to fire a call to a function that will do the vlooku
incode and then return the result and place that in the correspondin
text box or label.


Keith
www.kjtfs.co
 
Textbox2.Text = Application.Vlookup(Textbox1.Text, _
Worksheets("sheet1").Range("A1:B30"),2,0)
 
Back
Top