In the change event of the Worksheet object, you'll need something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 9 Then
MsgBox Target.Address & " was changed"
End If
End Sub



"Jack" wrote:

When user changes the cell value in selected column I would like to do some
recalculation.
How to get such notification?
I am using vbasic and Excel automation.
Jack