Put data in a ListBox or ComboBox

In a ListBox or ComboBox with a single column, the AddItem method provides an effective technique for adding an individual entry to the list.

In a multi-column ListBox or ComboBox, however, the List and Column properties offer another technique; you can load the list from a two-dimensional array.

See also

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.