running macro when updating a cell 1

[BoFenger]

Hi TT
I'am using VBA under excel
Is it possible to run a macro when a normal cell is changed, fx. from 6 to 15

\Bo

 

[murad5]

You can do this by using the Change event of a worksheet. If you want to specify a particular cell, check if the "TARGET" cell is the correct cell.

 

[Chattin]

An example

Private Sub Worksheet_Change(ByVal Target As Range)
Dim KeyCells As Range

' The variable KeyCells contains the cells that will
' cause an alert when they are changed.
Set KeyCells = Range("A1:C10&quot

If Not Application.Intersect(KeyCells, Range(Target.Address)) _
Is Nothing Then

' Display a message when one of the designated cells has been
' changed.
' Place your code here.
MsgBox "Cell " & Target.Address & " has changed."

End If
End Sub

HTH

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help