Find Index of Multi Col listbox and write to cell

tahano54

New Member
Joined
Apr 1, 2015
Messages
2
I have a list box created thusly

Code:
 'Populate Jurisdiction
 
     With Me.ListBox _Jurisdiction
        .ColumnCount = 2
        For i = 1 To 35
            .AddItem Range("Tables!C2:C36").Cells(i, 1).Value
            .List(.ListCount - 1, 1) = Range("Tables!D2:D36").Cells(i, 1).Value
        Next i
    End With
That loads it fine, so now I've selected an item in the list. say number 10. As I'm understanding so far, this is a zero base 2 dimensional array, so the index would be for column 1 item 10 a index of 0,9. If I wanted the element in the second column that index would be 1,9. Correct?
From my research, I have to find the index of whatever item I've selected and this goes in the Click_Change event which seem to have issues if I'm understanding correctly.
So,

Code:
str =Me.ListBox _Jurisdiction(.ListIndex,0)
in the change event would geve me a value that I could write to a cell?

Any guidance would be appreciated.
Thanks
 

Forum statistics

Threads
1,085,496
Messages
5,384,000
Members
401,871
Latest member
allemandi

Some videos you may like

This Week's Hot Topics

Top