retrieving listbox values

[austin350s10]

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.

My Attempt:

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

 

[AlphaFrog]

This should work...

myClientID = clientList.List(clientList.ListIndex, 0)

The error may occur when nothing is selected in the list. This would test if anything is selected.

    [color=darkblue]If[/color] clientList.ListIndex > -1 [color=darkblue]Then[/color]
        myClientID = clientList.List(clientList.ListIndex, 0)
    [color=darkblue]Else[/color]
        MsgBox "Nothing selected"
    [color=darkblue]End[/color] [color=darkblue]If[/color]

 

[Norie]

If it's just one value you want then you can use the Value property, provided the column which contains the value is the BoundColumn of the listbox.

 

[mikerickson]

This is slightly off topic, but I noticed that .BoundColumn is usually a 1 based property.
When .BoundColumn = 0, the .Value property returns the same as the .ListIndex

 

[austin350s10]

Thank you....def a retard...lol The first part of my code resets the list. so that why I could get the selected value....WOW

 

[Norie]

I've done that plenty of times.