I have 2 listboxes (both with same rowsource). They are labelled Invited and Present.

What I want to do is return all the values that are selected in the Invited listbox but not selected in the Present listbox. I have tried with code below, I don't get any errors, but it does not return anything. Any help would be much appreciated.

For Inv = 0 To UF_Meetings.ListBoxInvited.ListCount - 1
        If UF_Meetings.ListBoxInvited.Selected(Inv) = True Then
        CountInvAndPre = 0
            For p = 0 To UF_Meetings.ListBoxPresent.ListCount - 1
            
                If UF_Meetings.ListBoxInvited.Selected(Inv) = UF_Meetings.ListBoxPresent.Selected(p) Then
                CountInvAndPre = CountInvAndPre + 1
                End If
            Next
            If CountInvAndPre = 0 Then
            Invited = Application.WorksheetFunction.Index(Range("f_roster_tbl[E-mail]"), Inv + 1, False) & "; " & Invited
            End If
        End If

    Next
I aiming for 'Invited' to return a de-limited list for example "adam@xyz.com; bert@xyz.com" to use in creating an email