View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chris[_2_] chris[_2_] is offline
external usenet poster
 
Posts: 6
Default Assign variable ListBox names

I have a user form with three list boxes. Is there a "For" statement
(similar to below) that will loop through each of the three list boxes
and execute a "with" command?

For x = 1 to 3
With UserForm1.ListBox(x)
.additem = A
.additem = B
End With
next x

Any help is greatly appreciated, thank you!