Excel macro

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I need a help in using the excel macro

I have designed the Userform for searching the particular value from the excel.By typing the value in the textbox the related values should be displayed like a list displayed in google.

Plz help me

2 replies

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
46
Hi gayu,

Microsoft Excel's "Find and Replace" dialogue box (Ctrl + F) helps you serve this purpose. Instead of clicking "Find Next", click "Find All" and it will display the results in a list like Google search.

If you still want to try a Macro, please check the below mentioned link, it might be helpful in writing your macro:

https://ccm.net/faq/28020-excel-vba-a-find-search-with-multiple-return

Please do write back to us.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768