run macro when I change value in excel cell 1

[navyguy]

Hello, I am writing a visual basic macro for excel. I would like the maro to run whenever the user changes the value in a particular cell of the excel spreadsheet.

Any ideas....

Thanks

 

[acron]

Right click on the sheet tab of the sheet containg the cell, select View Code and enter the following :

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, [A1]) Is Nothing Then
     'Insert code or call to procedure here
End If
End Sub

replacing A1 with the address of the cell you are interested in and insert either the code you want to run or a call to some procedure you want to activate when that cell changes.

A.C.