Auto-refreshing combobox list when user is entering letters

Hi,

I've got some experience with forms and I've tried to find the answer, but it seems to be to difficult.

I want to make a form with a field (combobox, listbox or text box - I don't know which will be most suitable in this case) that will be auto resfreshing at the time of writing based on entry the user is making. The suggestions should be seen as a list of rows up to 10 and should be visible by user "online". My list of words would be around 500 and scrolling down to find the right one is impossibe.

Autocomplete method shows only 1 suggestion and gives only word that starts with the letter of list. I'd like to have more suggestions rows and also with combinations of inside letter combination.

Have any of you heard about this kind of procedure or idea? I guess that event procedures might be helpful here. I'd be so much pleased for any suggestions.
Daniel

Hi Alphafrog,

many thanks. In my case I have created 120 textboxes (yes I know ... so many) and I want your procedure works in all of them. I though about adding a tag to all textboxes, but what might be the tigger to run that the proceure?

So I click to any of 120 textboxes and your procedure start showing me suggestions, but I don't want to create each subprocedure for each textbox. Is there an event like "on userform click event". Is this a good direction? I can attach a file, if it will be helpful.

thanks,
Daniel