ExcelBanter - View Single Post - Selection in 1st list box populates 2nd list box

JE McGimpsey

See

http://www.contextures.com/xlDataVal02.html

In article . com,
wrote:

Simplified example of Table

Cars Chevy 1990
Cars Ford 1996
Cars Toyota 2001
Birds Eagle Big
Birds Crow Medium
Birds Chickadee Small

The first list box will be populated with the data from column A
(Cars, Birds)

After selecting "Cars" in column A, I would like a second List box to
populate with the next level of data in column B (Chevy, Ford,
Toyota).

After making that selection I can easily set up a vlookup based on a
key and return the correct value from column C.

The problem I am having is figuring out how to populate the 2nd list
box based on the selection in the 1st.

Does anyone know how to do this?

Thanks!!!!