Select order in Excel 2007 VBA Listbox

[phudgens]

Does anyone know of a way to determine the order in which items in a Listbox were selected by the user?

 

[dhookom]

I expect you could capture the ListIndex of the listbox during the On Change event like:

Private Sub lboMonth_Change()
    'assuming a label control names lblSelected
    Me.lblSelected.Caption = Me.lblSelected.Caption & Me.lboMonth.ListIndex & "~"
    Debug.Print Me.lboMonth.ListIndex
End Sub

This will stick the values as clicked. You might need to remove values that are clicked a second time and possibly add some weird character between the values.

Duane
Hook'D on Access
MS Access MVP

 

[phudgens]

Thanks - that worked. I couldn't figure out how to get information back from the _Change event. I guess a label on the userform is the only way. I used a space for my weird character.

 

[dhookom]

Space should work as long as the values don't have spaces.

Duane
Hook'D on Access
MS Access MVP

 

[phudgens]

They don't - they're just the index of the selected items. Thanks.