Cycle through a loop in VBA

Question

I have a form in VBA where I want a combo box (cboIncluded) to change its dropdown values according to what's chosen in a different combo box(cboSelectParty).

It provides choices correctly the first time I choose something from cboSelectParty, and if I choose again from either my If or elseif.

My problem is, if I have chosen from either the if or elseif (Fun climb party or climbing party), if won't go back to giving me correct options if I choose anything else.

Private Sub cboSelectParty_AfterUpdate()
 
 cboIncluded.Value = ""
    If cboSelectParty.Value = "Fun Climb Party" Then
       cboIncluded.List = Sheets("PartyImport").Range("N3:N4").Value
    ElseIf cboSelectParty.Value = "Climbing Party" Then
       cboIncluded.List = Sheets("PartyImport").Range("O3:O6").Value
    Else
       cboIncluded.Value = Application.WorksheetFunction.VLookup(cboSelectParty.Value, 
       Sheets("PartyImport").Range("E2:H37"), 4, False)
    End If   

End Sub

Answer 1

At last, i found the answer by my self. My gut feeling leads to the setup on windows server setup to enable the web socket protocol.

This is what i did to solve the issues:

(1) On my server , windows start, i typed Server Manager

(2) Then i select (2) Add Roles and features.

(3) A pop up window will appear, click next

(4) Click Next

(5) On "Select server roles", expand Web Server (IIS). Expand the next Web Server check box again, then expand Application Development. Now, make sure you check the check box for WebSocket Protocol. Then click next.

(6) Click Next and then click Install.