Ok so I am working on a userform that contains a listbox with 3 columns in it (bound column = 0). I'm filling this listbox from a database using .additem. When I attempt the retrieve the first columns selected value I am unable to do so. The MultiSelect property of the listbox is set to: 0 - fmMultiSelectSingle Hoping someone understands this better than I.
Private Sub clientList_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Dim myClientID As String ' I tried each of the 3 methods below with no luck myClientID = clientList.List(clientList.ListIndex, 0) ' GIVES ME: Run time error 381: Could not get the List property. Invalid property array index. myClientID = clientList.Value ' GIVES ME: Run time error 94: Invalid use of Null myClientID = clientList.Column(0, clientList.RowSource) ' GIVES ME: Run time error 381: Could not get the List property. Invalid property array index. MsgBox myClientID End Sub