View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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,