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.
Bookmarks