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
|