Filtering a combo box

S

Steve Stasko

I have a spreadsheet with 2 combo boxes. The first box
calls from a list of 5 items. The second box calls from a
list of 50, and they are related to combo box 1. How do I
filter combo box 2 so that only items related to combo box
1 show in the list? These combo boxes will be copied down
the page for multiple selections. Is this possible and if
so how ? .....Thanks
 
M

mzehr

Hi Steve,
I don't know if you're committed to a combo box or not. If
not you might consider using data validation, which will
probably work much faster than a combo box. Debra
Dalgleish has an excellent website devoted to similar
scenarios as what you are describing below.
Check out her website at
http://www.contextures.com/excelfiles.html#DataVal
and look for ScenarioParts.

HTH.
 
S

steve

This is not what I had in mind. I would like to stay with
combo boxes. The cells in column A contain items that
have an associated category and severity. The category
and severity have risk values that are multiplied to give
an overall risk. The severity selections are related to
the category, and in the severity combo box I only want
related selections to appear for a corresponding category
in the same row. Hope this makes sense. Again thanks for
any help.
 
Top