Helo people and thank you in advance for your help.
Im new on vb for applications from Excel and I was wondering that if I have a multicolumn listbox, how do I Access each column value selected?
meaning, I have something like:
Set obj_rst = New ADODB.Recordset
.Open "SELECT [Customer], [Country] FROM [tbl_one] where Year =" & sYear, obj_Conn, adOpenStatic, adLockReadOnly
If Not obj_rst.EOF Then
i = 0
obj_Listbox.List(i, 0) = obj_rst![Customer]
obj_Listbox.List(i, 1) = obj_rst![Country]
i = i + 1
Loop Until obj_rst.EOF
How can I know the customer and country selected ?
Moved byShanks ZenFriday, April 26, 2013 7:50 AMFrom Visual Basic