Text appearing after some time un Text Box (ActiveX Control)

Hi Team,

I have created a price checker for my company- whatever I type in the Text Box (Inserted from Developer Tab) comes slowly. What is the reason?
In this search box, i can use "*" to narrow the search (more accurate results will appear below) but the problem is I cannot use it in the reverse order.
For e.g. If for showing the result, Microfiber Cloth, i have to search like this "Microfiber or Micro*fiber* etc. I need to get the results even if the search is in reverse order- for e.g. "Cloth*micro* . Is that possible?

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.





To add a file to a post

Suppose your data in "A2" as Microfiber Cloth
In "B2"

Formula:

Please Login or Register  to view this content.

Here you go.

Please suggest a non-array formula for the below- refer the attachment in my previous post.

{=IFERROR(IF(F8="","",INDEX(Data!$B$2:$B$101,MATCH(0,IF(SEARCH(Summary!$E$3,Data!$B$2:$B$101),COUNTIF(Summary!$F$8:$F8,Data!$B$2:$B$101),""),0))),"")}

Try

F8

Formula:

Please Login or Register  to view this content.

and drag down!!

Tried, not working properly.
Can you please try in the sheet which i had uploaded.
Assume the text range is between B2 to B11000.

Check the attached file

Great. Thank you.

can you give me a tip to speed up the typing in Textbox, it's so slow when there is more lines.

Check the attached file... May be it should work little fast.

It's better now, but when we type the letter, it comes (visible on the textbox) after a few seconds, why it's like that?

Try

Open Excel --> Options --> Advanced --> Under display options --> Check "Disable hardware graphics acceleration". Restart excel.