Excel VBA code to copy active cell in specific column to fixed defined cell

Question

I've been looking for a way to code in VBA: when I click on a certain cell (doesn't matter which one, as long it's in column X), Excel should copy that cell value to a specific cell B10.

Can anyone help please? Probably simple, but I get errors every time!

Thanks!

Answer 1

Try the Worksheet_SelectionChange event for that worksheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Column = 19 Then ' check if cell modifed is in column "S"
    Target.Copy Range("B10")
End If

End Sub