Assign variable ListBox names

  • Thread starter Thread starter chris
  • Start date Start date
C

chris

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!
 
For x = 1 to 3
With UserForm1.Controls("ListBox" & i)
.additem = A
.additem = B
End With
next x
 
Is it safe to assume that the "i" should be an "x"? I am also
receiving a Run-time error '438'. Any ideas for a solution?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate Form Name to Parse for function 1
Listbox Output to Individual Listboxes 1
Variable Problem 3
Prgrammatically added OLE Listbox, now cannot select from it 9
Problem with multiselect listbox items selection 2
sorting a listbox in a user form 4
Listbox text property not working correctly 2
Stopping duplications been entered into a listbox 8

Back
Top