Good Morning,

I am trying to have a userform where when you select a vendor the other boxes (contact name, email, and phone) are populated with those items.

I have set up a dynamic combo box that pulls from a list on a sheet and I want when you select the vendor for the contact stuff which is next to it on the list page to populate the text boxes in the userform.

But if they do not select a vendor from the list I want them to stay blank so you can enter them in manually.

Help would be much appreciated this is my first attempt at userforms.

Thanks!


StrotherAuto Populate Textbox based on Combo box selection.xlsm