L
L Scholes
I am having trouble in VBA using names. I have created a dynamic list
for use in combo box with VBA, this list is
"DealerList."(=OFFSET(LookupLists!$A$1,0,0,COUNTA(LookupLists!$A:$A),1))
I want to create a list of Authorized Signatures name "Signature" where
if a Dealer is selected in the first combo box, only the authorized
signatures are displayed for that particular dealership. The questions
are: where do I enter the names, and, using VBA, how do I set up
another combo box to only list the appropriate signatures, not all of
the signatures for 15 or dealerships? I already have a user form
created using the process described here:
http://www.contextures.com/xlUserForm02.html, I just can't get the
lists to work properly.
Thanks in advance.
for use in combo box with VBA, this list is
"DealerList."(=OFFSET(LookupLists!$A$1,0,0,COUNTA(LookupLists!$A:$A),1))
I want to create a list of Authorized Signatures name "Signature" where
if a Dealer is selected in the first combo box, only the authorized
signatures are displayed for that particular dealership. The questions
are: where do I enter the names, and, using VBA, how do I set up
another combo box to only list the appropriate signatures, not all of
the signatures for 15 or dealerships? I already have a user form
created using the process described here:
http://www.contextures.com/xlUserForm02.html, I just can't get the
lists to work properly.
Thanks in advance.