want to start a macro when click on a cell

[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

[Muddy]

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

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

[writelearner]

thanks a lot