I think I would have the choice data on a hidden sheet and apply an
autofilter. As the user makes selections, apply them to the filter on the
appropriate column. then loop through the visible rows and add the
acceptable choices to the next dropdown

Let Excel do the work for you.

--
Regards,
Tom Ogilvy

"Pete" wrote in message
...
My application is data entry in a flat sheet data list based on descending
variables of manufacturer, mode, part no, frequency, etc. The Excel hack
#24 in the O'Rielly book involve using worksheet functions COUNT,
INDIRECT,
MATCH, ADDRESS, AND COUNTIF in each succeeding column but are usable only
thru 2 columns before becoming unwieldy. In addition, entries in later
columns are not cleared if earlier selections are changed.

I know I've seen a more eligant solution, but I can't remember where.

"Tom Ogilvy" wrote:

I am not sure that Excel Hacks is that widely read by knowledgeable
users
since the contents are pretty much standard fare. Perhaps you could
elaborate on the general concept that is not workable.

A VBA solution would largely involve looping through your data and only
adding values that meet your previously established criteria to the
listbox.

However, the primary image I would have of this requirement would be on
a
database that exceeds 10 columns in width. If so, the solution I would
pursue would be an Autofilter. (found under Data=filter=Autofilter).
In
this situation, building dependent dropdowns would be reinventing the
wheel.

--
Regrds,
Tom Ogilvy

"Pete" wrote in message
...
I have tried the example in "Excell Hacks" but it is too complicated
to
extend over more than 2 columns. I would like to extend to 10
columns. A
VBA solution would be OK if necessary.