Removing an item in ComboBox list if already selected in the other Combobox

[nubranger]

I have 2 ComboBoxes. Both have same items inside. What I want to do is when say if "Report1" is selected in ComboBox1, ComboBox2 should not show "Report1" in the list and vice versa.

Thanks.

So far I only have this:

Private Sub Workbook_Open()

   Worksheets("Settings").ComboBox1.Value = Null
   Worksheets("Settings").ComboBox2.Value = Null
    
   With ThisWorkbook.Sheets("Settings").ComboBox1
    .AddItem "Report1"
    .AddItem "Report2"
    .AddItem "Report3"
    .AddItem "Report4"
   End With
   
    With ThisWorkbook.Sheets("Settings").ComboBox2
    .AddItem "Report1"
    .AddItem "Report2"
    .AddItem "Report3"
    .AddItem "Report4"
   End With

End Sub

 

[nubranger]

possible?