Cell to Run Macro

[Paul Norris]

Hi
I am stumped on running my macro; I wish to click on a cell and the Macro should then run, stumbling block is that the cell is pre formulated and need to remain visable so am unable to use buttons, any hints or tips would be great.
Thanks in advance
Paul

 

[taurean]

Right click on sheet tab and choose "View Code" and there you will find this worksheet level event code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" 'Your cell address will come here!
'Dosomething
End If
End Sub

This is default code for worksheet.

 

[Anthony47]

Rightclick on the tab with the name of the sheet, chose Display Code, put thi macro in the empty right frame

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$2" Then Call YourMacro
End Sub

This will invoke YourMacro whenever cell A2 is selected.
It could be wise, at the beginning of your macro, put Application.EnableEvents = False and restore "=True" on exit (beware of all possible sub exit); this is "mandatory" if YourMacro de-select and re-select A2.

Bye

PS: taurean was much faster in his response, see above

 

[Paul Norris]

Right click on sheet tab and choose "View Code" and there you will find this worksheet level event code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" 'Your cell address will come here!
'Dosomething
End If
End Sub

This is default code for worksheet.

Will give it a try and let you know Thanks

 

[Paul Norris]

Right click on sheet tab and choose "View Code" and there you will find this worksheet level event code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" 'Your cell address will come here!
'Dosomething
End If
End Sub

This is default code for worksheet.

Will give it a try and let you know Thanks