Add items to a list using the List or Column property

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.

See also

• Microsoft Forms reference
• Microsoft Forms conceptual topics

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.