Search worksheet from UserForm

[Pervaiz]

I have a userform with a
combobox having list different stores names i.e ("FOR", "EMP", "PAK", "GUJ") as i select a store in combobox the appropriate store excell worksheet opens under userform

I have few textboxes on the userform where i enter order number of the concern store in textbox1

i want when i enter order number in textbox1 other textboxes populate as per its information entered in its sheet columns with find or vlookup function from the columns please guide me any one a code for it

thanks

 

[Pervaiz]

i am using this code to find the record from "FOR" sheet as i enter some order number in textbox1, i want to find all the enteries in columns against this order number to populate in ret of the textboxes in userform2

UserForm2.TextBox2.Text = Application.WorksheetFunction.VLookup(UserForm2.TextBox1.Text, Worksheets("FOR").Range("A9:Y2500"), 4, 0)