MatchEntry Property

[De Bruce]

Good day all,
Please I have a comboBox named "prd" which displays all products listed in sheet1 Column A. Under the comboBox property, I have set the RowSource and also the MatchRequired to True, but the MatchEntry can only be set to MatchEntryComplete or MatchEntryFirstLetter.
Please I want a situation where I can match the first two to three letters upon typing in the ComboBox.
Thanks in advance.

 

[igold]

This video may be what you are looking for...

https://www.youtube.com/watch?time_continue=167&v=vOOuSe_s6pQ

 

[De Bruce]

This video may be what you are looking for...

https://www.youtube.com/watch?time_continue=167&v=vOOuSe_s6pQ

Thanks for the suggestion. I tried it but it is not giving me desired result

 

[Akuini]

I don't think there is a simple/direct way to do that.
You may want to set up a searchable combobox (using vba). You can find an example here:
https://www.mrexcel.com/forum/excel-questions/1089693-data-entry-force-selection.html

 

[Akuini]

If you just need 1 searchable combobox & want to insert the combobox value to a certain cell then you may need a simpler set up than the one in post #4 .
Here's is a simpler example:

https://www.dropbox.com/s/aa2dcrbmbfdkgx6/deCombobox - searchable example.xlsm?dl=0

 

[De Bruce]

If you just need 1 searchable combobox & want to insert the combobox value to a certain cell then you may need a simpler set up than the one in post #4 .
Here's is a simpler example:

https://www.dropbox.com/s/aa2dcrbmbfdkgx6/deCombobox - searchable example.xlsm?dl=0

Thanks bro, it worked very well. You saved a soul. Thanks so much

 

[Akuini]

You're welcome, glad to help, & thanks for the feedback.