I am in need of a way to get the selected items from a multi select list box in VBA. I tried this syntax, but it gives me an error of type mismatch. What is the appropriate way to capture all selected values from a multi select listbox?
Code:Private Sub Command14_Click() Dim I As Long For I = 0 To lstQB.ListCount - 1 Debug.Print lstQB.Value(I) Next End Sub