how to activate macro from cell

  • Thread starter Thread starter artzuka
  • Start date Start date
Hi,

You could do this. Right click your sheet tab, view code and paste this in
and then try selecting A1

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

Sub MyMacro()
MsgBox "You Did it"
End Sub

Mike
 
Thanks, It works well...

"Mike H" kirjoitti:
Hi,

You could do this. Right click your sheet tab, view code and paste this in
and then try selecting A1

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

Sub MyMacro()
MsgBox "You Did it"
End Sub

Mike
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting cell contents into a macro 1
After Macro runs, no cell activated - what am I missing? 2
to change the macros as per active cell and range 2
Activating hyperlinks 3
problems getting this macro to work 23
How can I get a macro to populate the answer into one specific cel 3
Disable running of SelectionChange macro when in another macro? 6
Macro command 3

Back
Top