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