Matching list
 

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
a 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 he
http://www.contextures.com/xlUserForm02.html, I just can't get the
lists to work properly.
Thanks in advance.

Matching list
 

Hi L,

See a response to your previous post.


---
Regards,
Norman



"L Scholes" wrote in message
oups.com...
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
a 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 he
http://www.contextures.com/xlUserForm02.html, I just can't get the
lists to work properly.
Thanks in advance.