combo box help please

[magicwand]

i am a new to excel.
i recently tried to build a page that calculate profit by agent an
agents's account.
our company have about 10 agents and each agents have about 10 account
associated with that agent.

i used combobox and populated with a list of agents. that was eas
enough.
now i want to fill second combobox to be populated with that agent'
account.
please advice me of best way to do what i explained.

i also want to make it easy to add new agent and account.
i speak php and actionscript so i am ok programer.

thanks in advanc

 

[JulieD]

Hi

you didn't say how you created the combo box ... so i'm not sure if the
following link will work for you - but it could be worth checking out
http://www.contextures.com/xlDataVal02.html

it's Debra Dalgleish's site on Data Validation - Dependent Lists

Cheers
JulieD