Forum menu
more excel vba help...
 

[Closed] more excel vba help, arrays

 mrmo
Posts: 10720
Free Member
Topic starter
 
[#1371251]

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 12:52 pm