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.

I am actually trying to enter the dealer name (in LookupLists!$A using
a combo box), the signature of the dealer ( in LookupLists!$B using a
combo box), a PO# (LookupLists!$C text box), and Date and Due Date
(LookupLists!$D and $E text boxes.) Is there an easier way to set up
this information than using the lists? Thanks

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.

Thank you very much. Just what I needed!