Use the Worksheet_SelectionChange method.\

This would go on the individual sheet in the VBA Editor

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address < "$B$3" Then Exit Sub
Do Stuff
End Sub

--
If this helps, please remember to click yes.


"Kent McPherson" wrote:

How do I execute a specific macro when I click on a cell? For example, if I
click in cell B3, I want to run a macro. Suggestions?