Yes i did to but im getting this error which why im asking to more experts: " There is more than one item with this name and is not clear which this refers…
For i=0 to ListBox2.ListCount -1
If ListBox2.Selected(i) then
total=total+Val(ListBox2.List(i,11))
TextField1.Text= format(total, “\$###,###,##0.00”)
End if
Next
I’m almost positive if you got that code to work it wouldn’t do what you wanted if you truly have 11 columns.
You’re going down each row to see if it’s selected, then when you find a selected row you try to get the entire column value of whatever row you’re on. Let’s say cell 2, 5 was selected. Your code will find row 2 selected, and try to get the value of column 2, even though row 2 is selected in column 5.