View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default Cell Selected to run Macro

Right click on your sheet tab and paste this into the code window

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then
MsgBox "Hello"
End If
End Sub

modify to suit your needs.

"Corey" wrote:

If i select a Cell, how can i run a macro, rather than having a button?

Regards

Corey