Populate userform text boxes with dater from another sheet, dependant on list box selectio

I would like to fill the text boxes on a Userform, with details from cells in another sheet. I have the select box populating with the "Customers" from the other sheet but I am having trouble working out tue "On click" code, to fill the text boxes with the data.

Any help would be appreciated.

mehmetcik, I am sorry you did not notice, that the user only has to click in a cell in column A and the form will open. I have done this to avoid having a button on the sheet, to open the form, obscuring data on the sheet. I will also use a macro to open a different form, to edit the details, if there is a “Quote_ID” in cell A. I have made a small form simply to find out how this is done, I would not expect anyone to do everything for me, just a little assistance, please.

I would appreciate any advice that you can offer.

Thank you

Thank you mehmetcik, I guess that I should have made it clearer, sorry.

Regarding the Customer ID number, I will need to see the first name - last name, to select the existing customer and then gather the details from that customer ID number. I hope this makes sense.

So basically, the enquiry will not generate a customer record, only when the booking is confirmed, will they become a customer. But, if they are an existing customer (repeat), all of their details will populate the text boxes.

I appreciate your help.

Thanks

Originally Posted by Norie

All you need to do is specify the sheet you want the data to come from in the code you use to populate the userform.

I'd post some code but I don't know which sheet the data is on or when you want to populate the userform.

Hi Norie, in the workbook attached to this post, there are 2 sheets, "Quote" and "Customers". If you click on any empty cell in colum "A" the form will open. This can be filled with details of an unknown person or it can be filled with the details of an existing customer. If you click on the "Existing Customer" (CommandButton1), a listbox will show a list of existing customers, from the "Customers" sheet.

This is a mock up of the end result and the form will have a lot more details on it. I am only trying to learn the principle here, so that I can work on making the eventual form work right.

Thanks for your interest.

Originally Posted by mehmetcik

I have included some error checking in this version to ensure tb2 and tb3 are text only

I have also enabled the delete key in TB1 to TB3

Thank you mehmetcik, That works fine, Now I know why it says "Forum Expert" under your name.