MatchEntry property, OptionButton control example

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:

• Three OptionButton controls named OptionButton1 through OptionButton3.
• A ComboBox named ComboBox1.

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

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.