dependant combobox list

  • Thread starter Thread starter L Sholes
  • Start date Start date
L

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.
 
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)
 
Back
Top