Take the 2-minute tour ×  How can I have a macro automatically
run whenever a cell in my excel spreadsheet is updated?
Private Sub Worksheet_Change(ByVal Target As Range)   If
Target.Address = "A1" And Target.Value > 0 Then      MsgBox ("A1
has changed.")  End If    End Sub `  But that's only when the
value becomes positive... How can I have this macro jump into
action when ANY change is made to A1? Also, does using a Private
Sub mean that this will constantly be monitoring my spreadsheet
for updates?  my problem is to export data from excel to SQL
Server when the cell is updated or changed  share|improve this
question  1 Answer 1  up vote 0 down vote accepted  Uhm, delete
the part "And Target.Value > 0"   share|improve this answer And
normally it will, as soon as the target cell is changed. This is
an event that should always be private in a sheet module. –  Kim
Gysen May 8 '12 at 13:11 means can u please elaborate – 
Devendar May 8 '12 at 14:02  Your Answer