Programming Excel with VBA and .NET

Name

control.List([Row, Column]) [= setting]

Synopsis

Sets or returns the value of one item within the list or all items in the list.

Argument	Settings
Row	The row of an item in the list
Column	The column of an item in the list

Omit Row and Column to get or set the array containing all items in the list. For example, the following code loads an array of strings into the control:

Private Sub UserForm_Initialize(  )
    ComboBox1.List = Split("This, that, other", ",")
    ' Select the first item.
    ComboBox1.ListIndex = 0
End Sub