Microsoft Excel VBA to : Find text from specific cell.

[Andrian2712]

Hello, my name is Andrian
I would like to have a Search Macro box to click to find text from specific cell.
I had a macro just to find the text. (CTRL + F)
it works just fine, but i need to have the macro highlight the text/cell from the text found from searching the text.
because workers here tend to miss the text found from the (CTRL + F) function.
and i know the macro shouldn't be as simple as (CTRL + F) macro only.
i've been searching this macro from google to google, and no luck.

help would be so appreciated

Thankyou

 

[DanteAmor]

Hi @Andrian2712 Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.


You may be interested in highlighting the entire row and column.

Check the following:

Highlight cross section/interest of current cell in table

Hi, Wish to colour fill my current cell within active table. Manged to do it via this code. But how do I automatically get this to work in any workbook/any active table? Also the current code removes existing colour fill both within the table and outside of the table. Is there a way to...

www.mrexcel.com

 

[Andrian2712]

Hi @Andrian2712 Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.


You may be interested in highlighting the entire row and column.

Check the following:

Highlight cross section/interest of current cell in table

Hi, Wish to colour fill my current cell within active table. Manged to do it via this code. But how do I automatically get this to work in any workbook/any active table? Also the current code removes existing colour fill both within the table and outside of the table. Is there a way to...

www.mrexcel.com

Hello sir, I think what I meant was this type of highlight,
Youtube source that I got :

I cannot really apply this type of highlight to my needs,
My needs was, highlight whenever the user tries to find specific text,

Example :
Data :
John
David
Alex
Marie
Anne
Grace

User tries to find :
David

When user clicks the macro button to find, then it will pointed to David cell
but i wanted an extra touch, so when the excel pointed to David cell, the cell also highlighted certain time, or blinked 2times if possible.

For the meantime, im still trying to figuring out how to put this to my needs

Thankyou for your respond.