LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 88
Default Multiple Listbox? Population

I have 32 list boxes on a userform. I want to populate them with the same
data. The list boxes are named listbox1, listbox2, etc.

Is there an easier way to populate these boxes instead of doing each one
separately?

Like a loop or something

Dim Counter, Listboxnumber AS Single
For Counter = 1 to 50
For lbnbr = 1 to 32
Listbox & Listboxnumber.additem Counter
Next Listboxnumber
Next Counter

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Population for multiple sheets Shaun Excel Discussion (Misc queries) 1 February 22nd 07 06:33 PM
ListBox population from Excel range Tim Coddington Excel Programming 4 July 11th 04 02:12 AM
ListBox Multiple Selection Todd Huttenstine Excel Programming 1 April 26th 04 06:15 PM
excel - ListBox multiple Select sjvenz Excel Programming 4 December 9th 03 08:52 AM
listbox.value not equal to listbox.list(listbox.listindex,0) ARB Excel Programming 0 October 22nd 03 12:46 AM


All times are GMT +1. The time now is 04:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"