Wild card suggestions in a textbox

[Yusuf]

Hi everyone

I have various lists of tools with different sku numbers which are very similar and at the moment, we are using Ctrl+F but very often we do not get the result because the first six characters are the same for many but the last three change.

Example, 123000123, 123000456, 123000789, 123000246

I was using Google and as I keyed "Mr E" then suggestions came up below and "Mr Excel" was the first in the selection.

Can this be done with VBA code using a Textbox for entries and a Listbox to display suggestions. The difference will be that the Listbox requires two columns. One for the suggestion and the second for the SKU number.

For example, if I keyed the word "hammer" then suggestions like "Short Hammer", "Plastic Hammer" or even "Hammer Head" or "Hammer Shaft" with the SKU number beside each.

Any help will be greatly appreciated.

Regards
Yusuf

 

[CharlesChuckieCharles]

use "*" either side of the list box row source code as in *Hammer* or *Ham*
and make the bound column the description

 

[Yusuf]

Thanks Charles

Do you have a basic example of code please.

Form1:
Textbox1, Listbox1,
Data:
Sheet1, A1:B5

Regards
Yusuf

 

[Yusuf]

Hi everyone

Does anyone have some tips or code extract to use the * before and after the keyed letters.
I'm not sure how the letter triggers the code to produce the wild card results.

Regards
Yusuf