It shouldn't make a difference if you use 1 or 2 comboboxes. You can also
use a list boxex.

The userform should have a Contol Button to exit the userform. The click
function for each user box should update the other list boxes as necessary.

I think you need 4 list boxes not 2.
1) Lists all Companies
2) List Products that selected Companies sell
3) List All Products
4) List Comanies that sell selected products.

Another suggestion.
Use 2 Buttons to either select Companies or Products. Then have two list
boxes with the order based on the selected button.



"mwam423" wrote:

greetings! i have two combo boxes in a user form and would like to run a
macro once a choice is made in one of the combo boxes. macro narrows down
the possibilities in subsequent combo box once a selection is first made in
either combo box.

example: combo box 1 is a choice of companies: A, B, C, or D. combo box 2
is list of products sold to that company. would like the list of products
to be able to change depending on which company is selected. additionally,
if a product is chosen from combo box 2, would like combo box 1 to show only
those companies that buy that particular product.

or does it make more sense to have two user forms??