dependant combobox list

[L Sholes]

I am trying to add "salesman" information to a combobox that is
dependant upon the dealership name I insert in another combobox. I have
the dealership names in column A. Q: How do I get the second combox to
insert the appropriate name? Should I make a separate sheet using the
dealership names as headers, or can I add the salesmens name in the
rows beside the already-present dealership name? Then, how do I get the
second combobox to pick it up? I am using a Userform and VBA.

 

[Bob Phillips]

Have lists of salesman by dealearship in columns, name those lists
(Insert>Name>Define...) with the dealership names (no spaces), then see the
response in the other post on how to use them.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)