Bound Column Property

[Ajayi32]

I have a multiselect listbox with multiple columns.
Column 1 is Player Name
Column 2 is Player Salary

I want to define which column is being used in my code since the Bound Column Property will only allow me to choose one. How do I do this.

My code is below. Thanks

Private Sub Command4_Click()

Dim intSalary As Long
Dim varItm As Variant
Dim txtPlayers As String

intSalary = 0
For Each varItm In qbList.ItemsSelected
intSalary = intSalary +
qbList.ItemData(varItm)
Next varItm
Me.qbSal = intSalary
Exit_Command4_Click:
Exit Sub

End Sub

 

[raskew]

In a combo box you can use column notation to specify a specific column. For example, using

Me![MyCombo].Column(0) specifies the first column
Me![MyCombo].Column(1) specifies the second column,

Etc.

 

[Ajayi32]

I am working with a list box, not a combo box. Is there something I can do with a list box. I can you a combo box because I need to use the multiselect property