Automatic ENTER.

[Rumburak]

Howdy,

Column A has name.
In column B I have a formula that lists all the names that contain the letter / letters entered in cell D2.
I need a VBA code to display my name in column B without having to press enter after each letter entered in D2.

Eg. I write a letter - let's say - the letter a, and without pressing enter to list all those names that contain the letter a
If I write - let's say - letters need to display all the names that contain these letters, but if I delete the letter c to display only the names containing the letter a.
Some kind of automatic ENTER.

Thank you.

 

[Logit]

.
It sounds like you need to utilize the : Private Sub Worksheet_SelectionChange(ByVal Target As Range) or Private Sub Worksheet_Change(ByVal Target As Range)

depending on your code and the ultimate goal.

More specifically, are you wanting to search Column A for names that match what you are entering in D2 ? There could be one name or maybe more than one name depending on
what is entered ?

 

[mikerickson]

Have you tried AutoFilter dialog box rather than using cell D2?

 

[Rumburak]

.
It sounds like you need to utilize the : Private Sub Worksheet_SelectionChange(ByVal Target As Range) or Private Sub Worksheet_Change(ByVal Target As Range)

depending on your code and the ultimate goal.

More specifically, are you wanting to search Column A for names that match what you are entering in D2 ? There could be one name or maybe more than one name depending on
what is entered ?

Yes. This is what I want.


My current file contains, in column 1, column A, about 500 names.
In column B, I have a formula that lists those names that contain the letter / letters that are typed in cell D2.
If a code can be made that lists the names containing the letter / letters that are typed in cell D2 then we can quit the formula in column B.

Thank you.

 

[Rumburak]

Have you tried AutoFilter dialog box rather than using cell D2?

No. We need cell D2
AutoFilter it's not an option.
AutoFilter can not filter by some letters inside the names.

Thank you.

 

[Logit]

.
Hopefully you can utilize this project.

https://www.amazon.com/clouddrive/share/jkOlkMXBl0xn6S3zcAsaz9a5U9yF8ZsRxisjgz1vdwD

 

[shg]

Alternative to the formula in the FILTER column:

{=--OR(ISNUMBER(SEARCH($G$1, SearchTable[@[Name]:[Car]])))}

 

[Rumburak]

Thank you both of you.
I can't use helper column. From column C to BK we have data with many connection.

We need to simulate - pressing ENTER key - after we write/delete any character in D2, with VBA code.

Thank you.

 

[shg]

There are 16,231 columns to the right of BK. Why can't you use one of them?

 

[Rumburak]

There are 16,231 columns to the right of BK. Why can't you use one of them?

It's too much to explain why my boss does not want to use helper columns.

If you want to help me, it's OK, if not, stop asking questions.