Run Macro When Select Cell

[Andibevan]

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

[Mike Fogleman]

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" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
>