You are describing Dependent Lists.
See Debra Dalgleish's website for instructions on how to construct and use
them:
http://www.contextures.com/xlDataVal02.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Kim K" wrote:

How do I set up a list box say B that will depend ont eh answer of A?

I want to create a listbox so that A will be a choice of the school district
the student attends and Listbox B will be a choice of the schools within that
district.

I do not want to create the listbox B to be a choise of 67 schools from all
districts in our area. Thanks for the help!
--
Thanks,,
Kim