gototcm formulated the question :
This should be a simple extension of Dynamic pulldown Lists, but it
isnt obvious.

I have a simple pulldown list in cell a1, simply a,b,c done through data
validation. In cell a3 I created a dependent list so that if I selected
€œa€� in cell a1, I have a pulldown list that read apples, acorns. If I
selected €œb€� the depedent list is bubbles, baskets. I know how to do
this. I created a name €œa€� with two entries apples and acorns and did a
similar thing for the name €œb.€� This all works as advertised.

Heres the rub. Suppose I select €œa€� in cell a1, and then apples in
cell a3. But if go to cell a1 and clear the contents, the null string,
I want cell a3 to also clear. It doesnt and I cant figure out how to
accomplish this.

The end application is more complex and has several of these situations
so that is why I am asking.

I do a similar thing in a simple bookkeeping app where the 'Income' and
'Expense' ledgers have account dropdowns and dependant sub-account
dropdowns. Users must select an account, sub-account, and enter an
amount for each dated transaction. What displays in the sub-account
dropdown depends what was selected in the account dropdown, making the
sub-account dropdown 'context-sensitive' to the account dropdown. If a
user changes a selection in the account dropdown, the sub-account
dropdown turns red (both pattern and font) because its contents are no
longer 'in context' with its respective account dropdown. The behavior
of the sub-account is managed by CF based on the value in its
respective account dropdown.

The only way you can reset/clear the dependant cell is via VBA in a
_Change event. Otherwise, you could implement CF to 'cue' users that
something is missing in A1 and/or the contents of A3 are 'out of
context'. As you state in your final paragraph, this leads to the
project being somewhat complex. How you design the project is the key
to how easy the complexity is to manage!<g

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc