Excel: how to create an interactive popup form

Hi,
first of all thank you in advance for your help.
I have this problem:
I have a list of sites ("Sites").
In a different sheet ("Agents") I have a list of agents. Each agent is available for some of the sites.
I would like to have a way (maybe a button for each site) to open a popup in which I have a list of only the agents available for that site, so that I can select just one of them. Selecting an agent would put his data in the site line.

I attached an example

Place this code in the Worksheet module of sheet "Sites".
On the sheet Place an ActiveX Combobox "Combobox1", Place in one of the rows in column "C" next to a site.
To run code:-
When you click on a site in column "B" the combobox should appear in the next column, With the related names.
Select a name in the Combobox, then double click the combobox. The Combobox should now be hidden and the data relating to the selected name should show in columns "C & D".
Repeat for new site.

Please Login or Register  to view this content.

Thank you. It works!
Now, how do I change what is displayed in the combobox? I would like to display all the attributes of the agents, in order to choose.

For example, I would like in each row of the combobox, to display both name+surname and the email and possibly any other attributes I will put in the Agents sheet.

Second question: is it there a way to have the code running as soon as I open the file? (I don't want to require my users to activate anything)

Thank you again