This is Very werid, it's as if VBA in Excel 2003 has a bug....

If I do:
VB Code:
  1. For i = 0 To ListBox1.ListCount - 1            

  2.             If ListBox1.Selected(i) Then

  3.                 ListBox2.AddItem ListBox1.List(i)

  4.             End If

  5. Next
I get an error stating that it cannot get the selected property. When debugging I see that i is the same as Listbox1.ListCount, therefore, it is trying to get the selected value of an element that does not exist. So, I am having to put it as follows:
VB Code:
  1. For i = 0 To (ListBox1.ListCount - 1)

  2.         If i = ListBox1.ListCount Then Exit For

  3.             If ListBox1.Selected(i) Then

  4.                 ListBox2.AddItem ListBox1.List(i)

  5.             End If

  6. Next
Any ideas or thoughts about this?