Hello VBA Experts,

I am trying to do a Vlookup in a UserForm where it will get the input from a listbox, do a vlookup from a specific table from a specific sheet, and put the lookup value in a textbox in the original UserForm. For example, I have a worksheet called "Company" and in this worksheet I have the Company Name and their associated phone number. I have the button to show my UserForm on another worksheet in the same workbook. When I click the button, the UserForm appears. In this UserForm, I have a list box to show Company Names. Below the listbox I have a textbox for phone numbers. Instead of typing the phone number in all the time, I would like to know if there is a way to populate the phone number using a vlookup formula where it would take the value from the list box from the userform, go to the worksheet called "Company", find the phone number, and bring it back to the phone number textbox in the userform.

Please let me know if this is doable.

Thank you in advance for your help!

J