If a ComboBox is bound to a data source, the ComboBox inserts the value the user enters or selects into that data source. If a multi-column combo box is bound, the BoundColumn property determines which value is stored in the bound data source.
The list in a ComboBox consists of rows of data. Each row can have one or more columns, which can appear with or without headings. Some applications do not support column headings, others provide only limited support.
The default property of a ComboBox is the Value property. The default event of a ComboBox is the Change event.
If you want more than a single line of the list to appear at all times, you might want to use a ListBox instead of a ComboBox. If you want to use a ComboBox and limit values to those in the list, you can set the Style property of the ComboBox so the control looks like a drop-down list box.
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.