Need Macro to find the active cell value on entire worksheet

[warriorpoet7176]

Hi Friend,
Need your help once again
I have a worksheet on which I have activated the feature of highlighting the duplicate text in red color, I want a macro to find the active cell's value on entire worksheet by clicking on the button.

Thanks in Advance for your initiatives !!

[kalbasiatka]

literally

Please Login or Register  to view this content.

[bebo021999]

This will pop-up a message of active cell value by clicking in a Macro-assigned button:

Please Login or Register  to view this content.

[warriorpoet7176]

I am sorry, didn't get,

Would this find and navigate me to the cell where active cells data is available

I am looking for solution that when clicked on button than I am active cells text is picked and entire excel is searched for that particular text & I am navigated to that cell immediately.



Thanks & Regards

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[warriorpoet7176]

Does this help?

Please Login or Register  to view this content.

Hi John,
Thanks for the quick reply but how do I need to put it in commandbutton, I want it should work only when clicked on the button.

Please direct me with little more clarity

[JOHN H. DAVIS]

Can you use this?

https://support.office.com/en-us/art...d-9c72c843a283