Formula / VBA Code to Display in A1 (sheet 1) Current Cursor value of sheet 2 (Column A)

[Dharmesh Thakkar]

I would like a formula (or VBA Code) in Cell "A1" of sheet 1 that would give me the cursor value (column A) of sheet 2 .
In other words:
If the cursor were in Cell "C10" of sheet 2, then Cell "A1" of sheet 1 give me value of cell A10 of sheet 2

Any ideas.
Many Thanks

 

[jproffer]

This goes in the sheet code of sheet2:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Worksheets("Sheet1").Range("A1").Value = Target.Value
End Sub

 

[Dharmesh Thakkar]

Many thanks. Its work except value need from sheet 2 of column A
If the cursor were in Cell "C10" of sheet 2, then Cell "A1" of sheet 1 give me value of cell A10 of sheet 2

 

[Fluff]

Try

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Worksheets("Sheet1").Range("A1").Value = Me.Range("A" & Target.Row).Value
End Sub

 

[jproffer]

I missed the part about the offset in the OP. Sorry about that. Thanks Fluff.