• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

macro help

[pre]
Private prevCell As Range

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not prevCell Is Nothing Then

If prevCell.Address = "$A$2" Then

Call myMacro
End If
End If
Set prevCell = Target
End Sub
[/pre]

This is worksheet event code.

To implement it, select the sheet tab, right click, and

select View Code.

Paste this code into the code module that opens in the

VBIDE.

Then close the VBIDE and test it in Excel.
 
Back
Top