Combobox entires

[dave8]

I have a combobox with listfillrange of three columns of data (sheet2!A1:C20).

ColumnA ColumnB ColumnC
-------- -------- --------
Data1 Data2 Data3
...

I know if I do ComboBox1.Value --> this will get me Data1. How can I get the value in ColumnB, Data2?

 

[MickG]

Try

Private Sub ComboBox1_Change()
With ComboBox1
MsgBox .List(.ListIndex, 1)
End With
End Sub

 

[dave8]

Try

Private Sub ComboBox1_Change()
With ComboBox1
MsgBox .List(.ListIndex, 1)
End With
End Sub

Thank you. How much do you know about Listbox? I posted a entry about listbox but didn't get much help. I have an Active-x Listbox on a worksheet and values are loaded during run-time. The property of this listbox is set to multi with option (can check mutiple items). The problem I'm having is trying to access the last item using the scroll bar. The scroll bar down to the second to the last item of the list but I can't access the very last item. Do you understand why?

 

[MickG]

Not sure why that should be , Is it possible to add a couple of blank rows at the end of the code.
Mick