The following example uses the MatchEntry property to demonstrate character matching that is available for ComboBox and ListBox. In this example, the user can set the type of matching with the OptionButton controls and then type into the ComboBox to specify an item from its list.

To use this example, copy this sample code to the Declarations portion of a form. Make sure that the form contains: 

Private Sub OptionButton1_Click() ComboBox1.MatchEntry = fmMatchEntryNone End Sub Private Sub OptionButton2_Click() ComboBox1.MatchEntry = fmMatchEntryFirstLetter End Sub Private Sub OptionButton3_Click() ComboBox1.MatchEntry = fmMatchEntryComplete End Sub Private Sub UserForm_Initialize() Dim i As Integer For i = 1 To 9 ComboBox1.AddItem "Choice " & i Next i ComboBox1.AddItem "Chocoholic" OptionButton1.Caption = "No matching" OptionButton1.Value = True OptionButton2.Caption = "Basic matching" OptionButton3.Caption = "Extended matching" End Sub