software

I am using data validation techniques to create a drop down list that depends
upon the user's choice on an earlier drop down list. This is called
quot;Dependent Data Validationquot; in the wonderful Contextures website.

I want to use dynamic range definitions so that the lists can be altered
easily. But my dependent data validation cell does not seem to like this.

Does anyone know if dynamic range definitions create a special sort of
difficulty when used in this manner?

Art

Try giving us a few more details about how you are creating your dynamic
range names and your data validation settings. Maybe then we'll have enough
information to chance a suggestion.

***********
Regards,
Ron

XL2002, WinXP-Proquot;ArthurJquot; wrote:

gt; I am using data validation techniques to create a drop down list that depends
gt; upon the user's choice on an earlier drop down list. This is called
gt; quot;Dependent Data Validationquot; in the wonderful Contextures website.
gt;
gt; I want to use dynamic range definitions so that the lists can be altered
gt; easily. But my dependent data validation cell does not seem to like this.
gt;
gt; Does anyone know if dynamic range definitions create a special sort of
gt; difficulty when used in this manner?
gt;
gt; Art

There's information on the dependent data validation page that describes
how to use dynamic lists. Is that the technique you used:

www.contextures.com/xlDataVal02.html#DynamicArthurJ wrote:
gt; I am using data validation techniques to create a drop down list that depends
gt; upon the user's choice on an earlier drop down list. This is called
gt; quot;Dependent Data Validationquot; in the wonderful Contextures website.
gt;
gt; I want to use dynamic range definitions so that the lists can be altered
gt; easily. But my dependent data validation cell does not seem to like this.
gt;
gt; Does anyone know if dynamic range definitions create a special sort of
gt; difficulty when used in this manner?
gt;
gt; Art--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlDebra,

Yes, I believe I have followed the dynamic lists instructions properly from
your website. I have used them before with good success.

Example entered into the quot;Refers to:quot; box of Define Name dialog:

=offset(Lists!$B$4,0,0,COUNTA(Lists!$B:$B),1)

I actually used range names rather than the cells in the formula. I wonder
if that had something to do with the problem.

After I could not resolve the error I went back to just traditional name
ranges (non-dynamic). The dependent data validation is working fine now. (I
do have another issue that I am going to post in the Programming thread).

Thanks for your help.

Art

quot;Debra Dalgleishquot; wrote:

gt; There's information on the dependent data validation page that describes
gt; how to use dynamic lists. Is that the technique you used:
gt;
gt; www.contextures.com/xlDataVal02.html#Dynamic
gt;
gt;
gt; ArthurJ wrote:
gt; gt; I am using data validation techniques to create a drop down list that depends
gt; gt; upon the user's choice on an earlier drop down list. This is called
gt; gt; quot;Dependent Data Validationquot; in the wonderful Contextures website.
gt; gt;
gt; gt; I want to use dynamic range definitions so that the lists can be altered
gt; gt; easily. But my dependent data validation cell does not seem to like this.
gt; gt;
gt; gt; Does anyone know if dynamic range definitions create a special sort of
gt; gt; difficulty when used in this manner?
gt; gt;
gt; gt; Art
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

It looks like you created the dynamic range correctly. However, you
can't use these dynamic ranges in the dependent data validation formula.
The link that I included:

www.contextures.com/xlDataVal02.html#Dynamic

describes a workaround for the problem.ArthurJ wrote:
gt; Debra,
gt;
gt; Yes, I believe I have followed the dynamic lists instructions properly from
gt; your website. I have used them before with good success.
gt;
gt; Example entered into the quot;Refers to:quot; box of Define Name dialog:
gt;
gt; =offset(Lists!$B$4,0,0,COUNTA(Lists!$B:$B),1)
gt;
gt; I actually used range names rather than the cells in the formula. I wonder
gt; if that had something to do with the problem.
gt;
gt; After I could not resolve the error I went back to just traditional name
gt; ranges (non-dynamic). The dependent data validation is working fine now. (I
gt; do have another issue that I am going to post in the Programming thread).
gt;
gt; Thanks for your help.
gt;
gt; Art
gt;
gt; quot;Debra Dalgleishquot; wrote:
gt;
gt;
gt;gt;There's information on the dependent data validation page that describes
gt;gt;how to use dynamic lists. Is that the technique you used:
gt;gt;
gt;gt; www.contextures.com/xlDataVal02.html#Dynamic
gt;gt;
gt;gt;
gt;gt;ArthurJ wrote:
gt;gt;
gt;gt;gt;I am using data validation techniques to create a drop down list that depends
gt;gt;gt;upon the user's choice on an earlier drop down list. This is called
gt;gt;gt;quot;Dependent Data Validationquot; in the wonderful Contextures website.
gt;gt;gt;
gt;gt;gt;I want to use dynamic range definitions so that the lists can be altered
gt;gt;gt;easily. But my dependent data validation cell does not seem to like this.
gt;gt;gt;
gt;gt;gt;Does anyone know if dynamic range definitions create a special sort of
gt;gt;gt;difficulty when used in this manner?
gt;gt;gt;
gt;gt;gt;Art
gt;gt;
gt;gt;
gt;gt;--
gt;gt;Debra Dalgleish
gt;gt;Excel FAQ, Tips amp; Book List
gt;gt;www.contextures.com/tiptech.html
gt;gt;
gt;gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html