Hi,
I have a userform. On this form I have many text box's for customer details.
customer box.jpg
The button "New Customer" works. It uses the following code to add a new customer id number.
What I would like is, for the combo box (ComboBox1) to show the First name and last name of existing customers, from the "Customers" sheet.Please Login or Register to view this content.
customer sheet.jpg
Then, when I select one, their details are used to populate the userform.
Customer details.jpg
Bookmarks