Prev: Get Picture from Access OLE Object Field
Next: Return value from cell info
From: PraveenVis on 14 Jan 2010 02:26
I use ByVal to notify me of any change to column 5. However, the cells in the
column 5 contain a forumla and I want to be notified of a change in the
content of the column (different outputs based on the formula)

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 5 Then
MsgBox Target.Offset(0, -4).Value & " changed", vbInformation
End If


End Sub

From: Gary''s Student on 14 Jan 2010 05:32
Use the Calculate event. It runs whenever the worksheet is re-calculated.

You will need to use some static variables to "remember" the results of the
previous calculation.
--
Gary''s Student - gsnu200909


"PraveenVis" wrote:

> I use ByVal to notify me of any change to column 5. However, the cells in the
> column 5 contain a forumla and I want to be notified of a change in the
> content of the column (different outputs based on the formula)
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> If Target.Column = 5 Then
> MsgBox Target.Offset(0, -4).Value & " changed", vbInformation
> End If
>
>
> End Sub
>
 | 
Pages: 1
Prev: Get Picture from Access OLE Object Field
Next: Return value from cell info