Change Cell Event

  • Thread starter Thread starter snax500
  • Start date Start date
S

snax500

How do I code an event change macro that triggers when cell A2 is
changed.

Thanks
 
Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

If Target = ActiveSheet.Range("$A$2") Then
MsgBox "Hello"
End If

End Sub

substitute the msgbox with your code.......
hope that helps!
:)
susan
 
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'Private Sub Worksheet_Calculate()
On Error GoTo stoppit
Application.EnableEvents = False
With Me.Range("A2")
If .Value <> "" Then
MsgBox "A2 was just changed"
End If
End With
stoppit:
Application.EnableEvents = True
End Sub

Right-click on the sheet tab and "View Code"

Copy/paste into that sheet module. Edit to suit.


Gord Dibben MS Excel MVP
 
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

Run two macros for two different sheets 11
Trapping value before and after change 3
Cell content change Event 7
Include Dropdowns and Checkboxes in Worksheet Change event 1
Combine 2 columns in a dynamic range into one 7
Application.enableevents = false not working in workbook open even 5
RAND() Won't Trigger Worksheet_Change 5
Event triggered in Excel's cell by DDE 3

Back
Top