Refreshing a userform on Combobox selection

[bishoposiris]

I have two comboboxes on a userform. I want the selection of combobox2 to change based on the selection of combobox1. For example, If combobox1 has 1,2,3 as options and I pick 1 I want combobox2 to have options red, blue, green. If I pick 2 I want combobox2 to have options orange, purple, yellow. I know how to fill the comboboxes I just need to know how to refresh the userform when a combobox1 selection has been made so that combobox2 will reflect the corresponding options.

[grimes0332]

You don't say where these options come from, so will assume they're hard coded.

As an example, add a userform with 2 ComboBoxes, both with the default names and paste the following into the userform code window.

Please Login or Register  to view this content.

[bishoposiris]

I'm sure this would work but I ended up using a ComboBox_Change() sub instead. My code:

Please Login or Register  to view this content.

This works as intended. Every time a new Level 1 selection is made the Level 2 selection is changed and refreshed. Thanks for you reply.