want to start a macro when click on a cell

I would like to start a macro every time users click a certain cell, but i don't know how to do it

thanks

Quote:

---

Originally posted by writelearner
I would like to start a macro every time users click a certain cell, but i don't know how to do it

thanks

---

replace the message box call with a call to your macro in the code below to run it when cell A1 is clicked

VB Code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  If Target.Cells.Row = 1 Then
    If Target.Cells.Column = 1 Then
        MsgBox "Hi"
    End If
  End If
End Sub

thanks a lot