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