Get Return Value Of Active Cell On Change Of Selection Change

[Safal Shrestha]

Do I have to do it for different sheets in the same workbook?

[Gary's Student]

I believe that is correct.

[LalitPandey87]

You can try this and no need to replicate the code just follow the steps:

1. Open excel
2. Press Alt + F11
3. In the right side you can see Project explore if not press Ctrl + R
4. Double click on ThisWorkbook
5. Paste below code

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
    Range("a1").Value = ActiveCell.Value
End Sub

[Safal Shrestha]

Thanks. Also I used the sheet name so that I can get the desired result, whereever the active cell is cell A1 of sheet1 will show the content.