I'm looking for the correct If Then solution that can add items to combobox2 depending on the choice that's made with combobox1
So combobox1 has three choices (X, Y, Z). When a user selects X, the 2nd combobox should display A, B and C.
When a user selects Z in the first combobox, the 2nd should display G, H and I
Hopefully I explained good enough what I'm looking for and can I expand a working situation myself with other options