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)

"L Sholes" <pwpd406@bellsouth.net> wrote in message
news:1144663287.853714.277430@e56g2000cwe.googlegroups.com...
> 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.
>