I have a sheet with multiple columns and rows.

Column A is a category description
Column B is a subcategory description.

I'm setting up a userform with dropdown, or combo boxes. What i want
is on the change event of box 1, i want to set the rowsource property
of box 2 to return all subcategory values that have the same category
value. For example
A B
1 Over Me
2 Over You
3 Over Us
4 Under Them
5 Under Everyone

If I select "Over" In box 1, i need the range "B1:B3" for rowsource in
box 2. Help!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/