I have a table (tblEmails) on a worksheet, It has two columns. First column named Subcontractors and second named email.

I have created a userform with two listboxes (lboSubcontractors) and (lboEmails). I want the code to find the email addresses for all the subcontractors in the listbox and show them in the second listbox.

I am not sure how to go about this but I would say a loop to vlookup each name in the listbox?

I'd really appreciate any help with this!