more excel vba help...
 

MegaSack DRAW - 6pm Christmas Eve - LIVE on our YouTube Channel

[Closed] more excel vba help, arrays

0 Posts
1 Users
0 Reactions
51 Views
 mrmo
Posts: 10710
Free Member
Topic starter
 

I have a list populated by the following code.

It works but is clumsy.

ComboBox2.List = Array(combo2(1), combo2(2), combo2(3), combo2(4), combo2(5), combo2(6), combo2(7), combo2(8))

If there are only 2 items in the array this will show all 8 items and if there are 9 it won't show them all? the actual data is variable.

What is the way to generate the box contents to fit the array rather than second guessing the array?


 
Posted : 01/03/2010 11:52 am