Filter combobox from another combobox

I removed the rowsource reference for Arrangement (i.e.) Combobox4 and I made the drop down list of Combobox4 to get updated via coding.

The combobox4 will get updated based on the selection change of Combobox3

Here is the combobox3 change code.

Private Sub ComboBox3_Change()
Dim rMyRng As Range, r As Range

Set rMyRng = Sheets("BanquetDB").Range("I2:I10")

ComboBox4.Clear

For Each r In rMyRng
    If UCase(r.Value) = UCase(ComboBox3.Value) Then
        ComboBox4.AddItem r.Offset(, 1).Value
    End If
Next r

End Sub

Refer the attached file for details.

Please do it for the rest of the combobox based on the above method/logic

aimjhun -- you will not be gaining friends by bumping your thread every few hours or asking complete strangers to be your friend on this forum.

As an alternative strategy consider

- explaining the issue in the question
- breaking a complex issue down into sub-questions

If you need help with a problem, explain the problem in the text of your question. Don't expect people to download a workbook before they can learn what the question is about.

And please, don't bump your thread every few hours. I think the forum rules say that you may only bump if your question has not received a reply in 24 hours. You may soon find that if you ignore the forum rules, there will be no forum here for you. You'll be shown the door.

Your choice.