ExcelBanter - Listbox Selection Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Listbox Selection Help (https://www.excelbanter.com/excel-programming/355577-listbox-selection-help.html)

Matt[_38_]

Listbox Selection Help

Hi,

I have a multi-selection listbox where I need to find the value of each
selection using a loop. I don't know how to find the text of the
selected item.

With ListBox2
For i = 0 To .ListCount - 1
If .Selected(i) = True Then
Dim Y As String
Y = ???? This should be the text here

Thanks,

Toppers

Listbox Selection Help

Y=.list(i)

"Matt" wrote:

Hi,

I have a multi-selection listbox where I need to find the value of each
selection using a loop. I don't know how to find the text of the
selected item.

With ListBox2
For i = 0 To .ListCount - 1
If .Selected(i) = True Then
Dim Y As String
Y = ???? This should be the text here

Thanks,

All times are GMT +1. The time now is 01:00 AM.