How do you link list boxes
 

I'm trying to create a schedule which allows the user to select a state, and
based on the state selected, to choose a county or city within that state.

Can this be done, if so how?
--
Henry

How do you link list boxes
 

yes - send your email address and/or your file to me and I'll demo how it's
done -- easier to show than describe - send to me at
Bob Umlas Excel MVP

"Henry" wrote in message
...
I'm trying to create a schedule which allows the user to select a state,
and
based on the state selected, to choose a county or city within that state.

Can this be done, if so how?
--
Henry

How do you link list boxes
 

I would use Data Validation dropdowns that are drill-down dependent.

Pick a state then pick a county then pick a city

See Debra Dalgleish's site for how-to and a sample workbook.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Wed, 28 Apr 2010 12:21:01 -0700, Henry
wrote:

I'm trying to create a schedule which allows the user to select a state, and
based on the state selected, to choose a county or city within that state.

Can this be done, if so how?