How do I fill a cell depending on the ListBox value?

[DreyFox]

Hello! EDIT: Wrong title, sorry

For this problem of mine, I know what I need to do, but I'm not really sure where and how to implement it properly. So:

If the checkbox is selected, and the first combobox is selected, the options for the first combobox will be allowed to be selected. Then, if that happens the sub module (ClearComboBox1(), ClearComboBox2(), ....so on) function will be called to clear the remaining comboboxes. The code for clearing one of them is shown below:

Sub ClearComboBox1()
ActiveSheet.Shapes.Range(Array("ComboBox1")).Select
With Selection
    .ListFillRange = ""
End With
End Sub

ElseIf the first and second comboboxes are selected, then the 3rd, 4th, and 5th comboboxes are cleared. And so on. I'll show what I'm attempting to achieve with an image below:

So what I would like to do is, when two Cartridge options are selected the remaining 5 ComboBoxes are cleared. I would also like 4 options cleared when someone chooses a single Cartridge and checks the left checkboxes for a duplicate of the same one.

Any help would be appreciated.