Hey
I think i just have a syntax problem.
This isnt working. If I simply set the listbox by disregarding the N variable it works. (eg ListBox1, ListBox2, ListBox3)Private Sub UserForm_Initialize() Dim L As Object Dim N As Long For N = 1 To 3 Set L = ListBox(N) With L .AddItem "hi" End With Next N End Sub
Have I got my syntax wrong?
Could someone please help.
Bookmarks