Comments by ahawari09 (Top 3 by date)

I am using excel 2007, and this is the code used on listbox and it is populated with directories names when I select single directory name other list box will be populated with files names, and whenever I have the listbox active and item is selected and scroll down the mouse I will have the entire workbook goes into closing down and file recovery mode. Is there any way to prevent scrolling down while items are selected? or any other solutions. Thank.
Private Sub ListBox2_Click()
Dim strFile As String
Dim i As Integer
me.ListBox1.Clear
For i = 0 To Me.ListBox2.ListCount - 1
If Me.ListBox2.Selected(i) Then
strFile = Dir("C:\Users\hawari\Documents\TLC\" & Me.ListBox2.Text & "\*.xls")
Do While Len(strFile) > 0
ListBox1.AddItem strFile
strFile = Dir
Loop
End If
Next
End Sub

Reason for my vote of 5
Automatic vote of 5 for accepting answer.