Hi All,

I know you can run a macro when a new variable is entered in a cell, but can
you run a macro when a cell is selected?

Ta

Andi

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Range("J1:J100"), Target) Is Nothing Then
'Call your Macro
Else
End If
End Sub

Change the Intersect Range to whatever cell or range you want as the
trigger.
This code goes in the Worksheet Module, not a general module.

Mike F


"Andibevan" wrote in message
...
Hi All,

I know you can run a macro when a new variable is entered in a cell, but
can
you run a macro when a cell is selected?

Ta

Andi