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
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