dependant combobox list
 

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.

dependant combobox list
 

Have lists of salesman by dealearship in columns, name those lists
(InsertNameDefine...) 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" wrote in message
oups.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.