I created a small userform with a couple of comboboxes and tried this:

Option Explicit
Private Sub UserForm_Initialize()
With Me.ComboBox1
.Style = fmStyleDropDownList
.MatchEntry = fmMatchEntryComplete
.AddItem "E"
.AddItem "L"
.AddItem "N"
End With
End Sub


I couldn't duplicate your results.


Snowfire wrote:

This is driving me mad... I want a combobox to react in this way...
The combo will dropdown and provide a selection of three options "E"
"L" or "N"
If the user types in say... "E" it accepts this and moves on. If he
types say "R" it will complain and not move-on.
I can get the combo to select "E" from the dropdown and it works. But
type "E" (an exact match) and it complains.
I have gone through all the settings suggested in this newsgroup but
can't get this simple error trap and acceptance sequence...... I must
be missing the obvious can any one please help.

--

Dave Peterson