• This topic is empty.
Viewing 1 post (of 1 total)
  • more excel vba help, arrays
  • mrmo
    Free Member

    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?

Viewing 1 post (of 1 total)

The topic ‘more excel vba help, arrays’ is closed to new replies.