check and compare value entered in combobox

[Pookiemeister]

I am using VBA in Excel 2010. I was wondering if there is a simple way to check to see if the value entered in the combobox matches the already populated value within the combobox.

Private Sub cmbMonth_Enter()     
With Me.cmbMonth
        .AddItem "January"
        .AddItem "February"
        .AddItem "March"
        .AddItem "April"
        .AddItem "May"
        .AddItem "June"
        .AddItem "July"
        .AddItem "August"
        .AddItem "September"
        .AddItem "October"
        .AddItem "November"
        .AddItem "December"
    End With
End Sub

As you can see, this combobox is populated with the values of the names of the months. What I would like to do is, if the user manually types in a month and misspells it, on exit, check and see if what they entered matches with what is in the combobox, if not display a message box.

Thank you.

 

[My Aswer Is This]

Why not do it this way
Put this script in a Command Button:
Modify Combobox name

Private Sub CommandButton2_Click()
'Modified 5/31/18 4:02 AM EDT
Dim i As Long
For i = 1 To 12
    ComboBox4.AddItem Format(MonthName(i), "MMMM")
Next
End Sub

 

[Fluff]

If it's an activex control set the MatchEntry property to 1 - frmMatchEntryComplete