Dependent lists
 

I am creating a form that includes State, County, and Town. I have lists of
all US States, Counties, and Towns.

I want to create a list (Data, Validation, List?) of counties that the form
user can choose to fill a cell that depends on the State chosen. I then want
to create a list of Towns for the user to choose and fill a cell based on the
State and County chosen.

I am not versed in VBA, so I am hopeful to find functions that will
accomplish the task. Thanks.

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

tells you exactly how to accomplish your abjective

"AppraiserRon" wrote:

I am creating a form that includes State, County, and Town. I have lists of
all US States, Counties, and Towns.

I want to create a list (Data, Validation, List?) of counties that the form
user can choose to fill a cell that depends on the State chosen. I then want
to create a list of Towns for the user to choose and fill a cell based on the
State and County chosen.

I am not versed in VBA, so I am hopeful to find functions that will
accomplish the task. Thanks.