A
Aechelon
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!
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!