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
ComboBox Challenged
-
- GoldLounger
- Posts: 2628
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
ComboBox Challenged
Regards,
John
John
-
- Administrator
- Posts: 78481
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: ComboBox Challenged
Make sure that the MatchEntry property of the combo box is set to 1 - fmMatchEntryComplete.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- GoldLounger
- Posts: 2628
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Re: ComboBox Challenged
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
When I start typing an entry in, there is no movement from the first letter to subsequent letters being typed in.
Regards,
John
Regards,
John
John
-
- Administrator
- Posts: 78481
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: ComboBox Challenged
Could you post a small sample workbook that demonstrates the problem?
Best wishes,
Hans
Hans
-
- GoldLounger
- Posts: 2628
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Re: ComboBox Challenged
Hans,
Please find attached an example of the challenge that I am encountering.
Regards,
John
Please find attached an example of the challenge that I am encountering.
Regards,
John
You do not have the required permissions to view the files attached to this post.
Regards,
John
John
-
- Administrator
- Posts: 78481
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: ComboBox Challenged
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.
- 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.
Best wishes,
Hans
Hans
-
- GoldLounger
- Posts: 2628
- Joined: 26 Jan 2010, 16:31
- Location: Southern California