List Box to Populate Another List Box From A Range

Aladin posted this a while back:

"The method is as follows:

Enter in some column what follows:

{"USA";"FRANCE"}[ That's, enter USA in a cell, then FRANCE in the next cell down ]

Select these cells, go to the Name Box on the Formula Bar, and type COUNTRIES followed by enter.

Enter in a column next to COUNTRIES:

{"New York";"Pittsburgh";"Los Angeles";"Boston"}

Name this range of cells USA via the Name Box as described above.

Enter in a column next to USA:

{"Paris";"Nice";"Toulon"}

Name this range FRANCE.

Just to see how this works,

activate A1 in some worksheet in the same workbook;

activate Data|Validation;

choose 'List' for 'Allow';

enter as 'Source' the formula:

=COUNTRIES

click OK;

activate another cell in the same worksheet, say, C1;

activate Data|Validation;

choose 'List' for 'Allow';

enter as 'Source' the formula:

=INDIRECT(A1)

click OK.

Now you have two lists of which the 2nd depends on the selection from the 1st. "

RDK -

Thanks for the post back. I will take a look at it. I had create a solution on my own.

Basic concept would be to use autofilter, copy/paste visible cells then have the ListBox populate by a range.

Thanks,

Kurt

Glad to help Kurt.
I can tell you by personal experience that Aladin's solution works like a charm. It took me no time at all to populate my validation boxes once I had the ranges set up properly.