View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Wildman[_2_] Joe Wildman[_2_] is offline
external usenet poster
 
Posts: 30
Default List Box - Scroll Wheel on mouse crashes spreadsheet

Here is the code,

Private Sub ListBox1_Change()

Dim outString As String, i As Long

outString = vbNullString
With ListBox1
For i = 0 To .ListCount - 1
If .Selected(i) Then outString = outString & .List(i) & ", "
Next i
End With
Range("I2").Value = outString

End Sub