View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Kent McPherson[_2_] Kent McPherson[_2_] is offline
external usenet poster
 
Posts: 27
Default Exceute macro when cell is clicked

Yes, this is great. Thanks.

"Paul C" wrote in message
...
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?