Find as you type in listbox control - solution for multi-column listbox - vba dictionary

Try something like this:-

Please Login or Register  to view this content.

Regards Mick

hi, thanks for the reply. However this doesnt seem to work, and when i step through the code its not adding anything to the dictionary even when i enter the first letter of a word i know is on the list. The code from "if dic.exists(userfilter.value)" onwards is not processed. Perhaps im missing something? cheers

From your description, the code I sent does the following:-
You place a value in Userform (From column "B" of sheet Customer) like "Mychef" and the userform list box returns Columns 1 to 3 for the Row which has that name.
Perhaps you want something else ????

a slightly different version

Please Login or Register  to view this content.

@MickG - i see what you mean . For your code to work, the user has to type the whole word eg "Mychef". In this case what i would like is similar to what the first code i posted did, which was update the listbox after each keystroke. So in the "Mychef" example, as the user types "M", every company name with M in its name is returned, and with further keystrokes the list is filtered further. cheers

@nilem - hi, thanks for contributing. Your code works after the following slight modification:

Please Login or Register  to view this content.

I found that without those, the user has to use the correct case to search otherwise no or incorrect results are returned. I tested by typing "m", a letter which all 3 companies share, but only "Pethomes" was returned as its the only one with a lowercase m.

Many thanks