Userform - Multiple Search instantly

I have data on sheet named DATA. I have columns with the following names:

column A: no.
column B: Name
column C: id
column D: ***
column E: age
column F: date of birth
column G: IQ Test
column H: Meaning of Name

I designed a crude UserForm that includes some of the above.

My goal is to write a code that, by writing each of the fields, instantly searches on corresponding column in DATA sheet and show results in ListBox.

I know that a way is write code so that when change in any of the fields, the rows stored in the listbox and results limited to the new search value.

In this way, the list box is instantly limited by field changes. But I don't have the possibility to write its code.

Originally Posted by JohnTopley

I hope you don't mean this literallY but the name starts with "a" or whatever the character(s) is(are).

If you mean "a" ANYWHERE in the name (or "2" anwhere in an age -25, 32, 72) ..... Good luck !

I mean "a" ANYWHERE. If added a char to it , like m, "am" should be in the name "anywhere" not start with it, and for all field like this.

Originally Posted by sintek

This will give you an idea...Start typing in NAME or ID

Edit...

If above is what you want... then one small change...add red snippet

Please Login or Register  to view this content.

Also...play around with other settings...

I test it. "dr" nothing show Badra be in the list, and , when type anything in name field, so type a number to id , and delete that num in id, all field show in the listbox.

Originally Posted by JohnTopley

Try attached with Sintek "tweak"

Type, "dr" in name field, then type "ma" in *** field, results not true.

You...Are not being transparent with your requirement...

I explain:

Originally Posted by niksirat2030

My goal is to write a code that, by writing each of the fields, instantly searches on corresponding column in DATA sheet and show results in ListBox.

Also in title of question "Multiple Search instantly" I clear what i want.

Suppose there is a list with a lot of data in front of you.

First, in one of the fields, for example, in the "name", you enter a name or a part of it. The list is limited according to the given value.

Now you fill another field (in no order, completely arbitrary) for example "age".

What do you expect? It is only reasonable to expect that the previously limited list (by completely or partially filling a previously desired field) will be limited again according to the new value, bringing you closer to what you want and limiting the number of results.

And, when you delete part of any fields that you fill it, the list of results will be updated according to the remaining values.

All the difficulty of this issue is to do all the above things instantly.

Without this condition, it is easy to put a search button that by pressing it will apply any number of restrictions in the data list.

But when the search is instantaneous, against any change in any field, the last value in the ListBox must be updated.

Hello
With the following variant, you can filter on all fields without losing column headers:

So here's one more way. By using Recordset.

Artik

Originally Posted by sintek

Something like this...Perhaps

Great, thanks sintek for your answer, but not work for "***" field.

Originally Posted by sintek

Look at this...4 year old post...No need to re-invent the wheel...Here jindon has perfected this requirement...

When you delete some char in any fields, list do not update.

Originally Posted by beyond Excel

Hello
With the following variant, you can filter on all fields without losing column headers:

Thank you very much for your answer. It works perfectly.

Originally Posted by Artik

So here's one more way. By using Recordset.

Artik

Great, it works perfectly.