Hi Dave,

Pardon me for not explaining enough.

My goal is to present the service rep a list of company names in a
dropdown menu. When she selects the company name, I want to present
all the contacts available for that company.

Then, when she chooses the contact I want to populate cells on a
worksheet with the Company Name, Contact first name, last name email
address, work phone, and fax number. I'm thinking of putting each of
those in a textbox and then use the textbox to populate the cell.


The worksheet tblCustomerApproved has the following fields in a named
range called "Customers"

Column A=CompanyID
B=CompanyName

the worksheet tblContacts has the following fields in a named range
called "Contacts".

Column A=CompanyID
B=ContactID
C=Email
D=FirstName
E=LastName
F=SalesRepNum
G=Workphone
H=Extension
I=FaxNumber

I hope that makes more sense.

Thanks,

Dan