List Box Macro

[Guest]

Hi All,

I have a List Box to which I have assigned a macro. Can I do some sort of
loop that will run through all entries in the list box running the macro as
it goes?

Many thanks,

Al.

 

[Guest]

This code adds items and then displays the items

Private Sub ListBox1_Click()

'add number to list box
For i = 1 To 10

ListBox1.AddItem i
Next i

ListBoxCount = ListBox1.ListCount
For i = 1 To ListBoxCount

MsgBox (ListBox1.List(i))
Next i
End Sub