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.

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

"Alpur" wrote:

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.