ComboBox Challenged

[jstevens]

I created a ComboBox from the "control toolbox" and thought that by typing the first Letter of the name in the combobox it will go to the first record with that letter and the same with each subsequent letter. This is not what I'm experiencing.

Is there a setting in the ComboBox properties that should be set? I may have overlooked something.

Thanks,
John

[HansV]

Make sure that the MatchEntry property of the combo box is set to 1 - fmMatchEntryComplete.

x7.png

[jstevens]

I have the MatchEntry set to 1 - fmMatchEntryComplete.

When I start typing an entry in, there is no movement from the first letter to subsequent letters being typed in.

Regards,
John

[HansV]

Could you post a small sample workbook that demonstrates the problem?

[jstevens]

Hans,

Please find attached an example of the challenge that I am encountering.

Regards,
John

[HansV]

Thank you. The values in column C are text strings, but you have formatted them as a number. This confuses Excel. To correct this:
- Select column C.
- Apply General format in the Number tab of the Format Cells dialog.
- Click OK.
You should now be able to type a few characters and have the combo box jump to the first matching entry.

[jstevens]

Hans,

Thank you very much.

Regards,
John