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

Activesheet.Activecel.Value

[bebo021999]

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

Sub ActCell()
MsgBox activeCell.Value
End Sub

[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?

Sub warriorpoet7176()
Dim rcell As Range, x As String
x = ActiveCell.Value
For Each rcell In ActiveSheet.UsedRange
    If rcell = x Then
        rcell.Select
        MsgBox "Value Found Here"
    End If
Next rcell
    
End Sub

[warriorpoet7176]

Does this help?

Sub warriorpoet7176()
Dim rcell As Range, x As String
x = ActiveCell.Value
For Each rcell In ActiveSheet.UsedRange
    If rcell = x Then
        rcell.Select
        MsgBox "Value Found Here"
    End If
Next rcell
    
End Sub

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