ComboBox (cbo)

ComboBox - This control allows the user to either select an item from the drop-down list or to enter a different value into the textbox.

ComboBox vs ListBox

The advantage of this control over a listbox is that a value that is not in the list can be entered.
This control is similar to a listbox although a combobox is a drop-down box and it displays only one item at a time.
This is very similar to a list box although a drop down list of possibilities is displaying.

Adding to single column

You can use the "AddItem" method when you have a single column combobox.
If you try to add items to a combobox that has been assigned a RowSource property you will get a "permission denied" error.
You can set the current item using ListIndex.

cboComboBox1.AddItem "one" 
cboComboBox1.AddItem "two" 
cboComboBox1.ListIndex = 1 (zero based) 

Currently selected item

Obtaining the currently selected item in a combo box.

Call Msgbox (cboComboBox1.Value) 

Select a value

cboComboBox1.Value = "some text" 

Cycle through the whole list

For icount = 0 To cboComboBox1.ListCount - 1 
   If cboComboBox1.List(icount) = "match" Then 
   End If 
Next icount 

Multiple Columns

cboComboBox1.ColumnCount = 2 
cboComboBox1.ColumnWidths = "40;40" 
cboComboBox1.AddItem "one" 
cboComboBox1.List(0, 1) = "three" 

cboComboBox1.AddItem "two", 1 
cboComboBox1.List(1, 1) = "four" 

Changing the Style

cboComboBox1.Style = fmStyle.fmStyleDropDownCombo 
cboComboBox1.Style = fmStyle.fmStyleDropDownList 

To remove scrollbars from appearing set the ColumnWidths to the width of the combobox
In order to have a short combobox or listbox with the dropdown the same width as the text box make the ListWidth property the same value as the width and make the column width the same as the width as well.
The user can also enter a value that does not appear in the list.
To only allow the users to select from the available list change the "Style" property to 2
If you do not want the user to select an entry then change the "MatchEntry" property to -1.
If not then you may get an "Invalid Property Value" error
LinkedCell - 2003
ListFillRange - 2003

Properties

Methods

Events