Run a macro when a user clicks in a certain cell

**NickySA** · 03-16-2007, 08:03 AM

I need to run a macro when a user clicks in a certain cell.
e.g. When a user clicks in any cell, say any cell between cells c10 and c20, I would like to run a macro that I have already created.

**mudraker** · 03-16-2007, 08:11 AM

This macro works whenever cells C10 to C20 are selected. This could be by clicking, tabing etc

'To install macro to correct location

'Copy this macro
'GoTo Excel
'Select sheet this is to appy to
'Right Click on Sheet Name Tab > select View Code
'Past macro into the Worksheet Module displayed

Change MyMacro as required

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   If Not Application.Intersect(Target, Range("c10:c20")) Is Nothing Then
      Call Mymacro
   End If
End Sub