dependant combo box

[L Scholes]

I am making a userform that allows users to enter data about car
dealerships. I have a combobox (cboDealer) that displays a dynamic list
(DealerList) of dealerships. I also have a combobox (cboSig) that
allows the user to enter the name of the person who authorized a
transaction. I want cboSig to dropdown only a list of authorized
persons from the dealership selected in cboDealer. Any ideas on how to
organize the authorized names in relationship to the dealership name to
allow separate dynamic lists for each dealership? And then how do I
code cboSig to only allow the appropriate names?

DealerList =
OFFSET(LookupLists!$A$2,0,0,(COUNTA(LookupLists!$A:$A)-1),1)
All dealership names are in ColumnA. Should I insert the signature
names in the rows to the right of each dealership? or create 15
separate columns, using the the dealership name as a header and create
separate dynamic names for each?

Thanks for any help.

 

[fredg]

I am making a userform that allows users to enter data about car
dealerships. I have a combobox (cboDealer) that displays a dynamic list
(DealerList) of dealerships. I also have a combobox (cboSig) that
allows the user to enter the name of the person who authorized a
transaction. I want cboSig to dropdown only a list of authorized
persons from the dealership selected in cboDealer. Any ideas on how to
organize the authorized names in relationship to the dealership name to
allow separate dynamic lists for each dealership? And then how do I
code cboSig to only allow the appropriate names?

DealerList =
OFFSET(LookupLists!$A$2,0,0,(COUNTA(LookupLists!$A:$A)-1),1)
All dealership names are in ColumnA. Should I insert the signature
names in the rows to the right of each dealership? or create 15
separate columns, using the the dealership name as a header and create
separate dynamic names for each?

Thanks for any help.

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the Excel Newsgroup. I would suggest you include your
Windows and Office version number in the message.

 

[L Scholes]

Thank you, and I'm sorry.