Hi L,

See xlDynamic's Dynamic Dependent Dropdowns page at:

http://www.xldynamic.com/source/xld.Dropdowns.html

Also, see Debra Dalgleish at:

http://www.contextures.com/xlDataVal02.html

and

http://www.contextures.com/xlDataVal13.html


---
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.