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
Bookmarks