Using Vlookup in a userform to display data from search criteria?

[jvenning]

Hi all. I've created a userform that saves data of a customer and their vehicle into a worksheet. I would like to view the data again after I have saved it into the sheet so I have created another userform that I would like to retrieve the data from the sheet and display in textboxes.

When I enter the registration number into 'textbox1' and press OK, I would ideally like all the data that I entered to be displayed in 'textbox2', 'textbox3' etc... The data comes from a sheet called 'Cust' with data from A1:A100 to K1:K100.

Any help would be much appreciated!

Regards,
J.Venning

[lucas]

Why not just use a listbox to select the reg number and then use offset to put the data into the textboxes....the example puts the info into labels instead but you get the idea.

use the search textbox to find your item