| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Listbox B if LIstbox A equals
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listbox B if LIstbox A equals
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listbox B if LIstbox A equals
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add Listbox header using VBA | Excel Discussion (Misc queries) | |||
| Listbox & Selection | Excel Discussion (Misc queries) | |||
| Using a ListBox selection to query a database | Excel Discussion (Misc queries) | |||
| Apostrophes instead of equals in Excel | Excel Worksheet Functions | |||
| Help with Excel ActiveX listbox controls | Excel Discussion (Misc queries) | |||
Linear Mode
