Userform Have Text Boxes Auto Populate Based on Combobox Selection

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

i made some changes....look them over.

Auto Populate Textbox based on Combo box selection.xls

Wow thank you could you explain why using those public constants is helpful I am still trying to learn VBA, a lot to learn obviously haha

I use the public constants JUST in case something changes, then I only need to change 1 thing. (and not miss others by doing global change)
But sheets should not change. (but never say never)