Add items to a list using the List or Column property

  • Article

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

  1. Create a multicolumn ListBox or ComboBox.

  2. Create a two-dimensional array that contains the items you want to put in the list.

  3. Set the ColumnCount property of the ListBox or ComboBox to match the number of entries in the list.

  4. Do one of the following:

    • Assign the array as the value of the List property. The contents of the ListBox will match the contents of the array exactly.

    • Assign the array as the value of the Column property. Column transposes rows and columns, so each row of the ListBox matches the corresponding column of the array.