I have a list box created thusly
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,
in the change event would geve me a value that I could write to a cell?
Any guidance would be appreciated.
Thanks
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
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