Getting desktop notification when a column is updated

[redjohn87]

Hi people,

I have an excel spreadsheet. It gets all data from external source, and refreshs itself in every 1-2 min. I need to get desktop notifications when a specific column updated and changed in my spreadsheet while it is running and minimized in desktop. Excel version is 2010. I have googled and did not found an exact solution. I am attaching the screen of the column. In advance thank you very much for your help.

 

[Coding4Fun]

You would right click the sheet you want this in and put the code in the sheet this data is stored in.

For more info see this link
https://support.microsoft.com/en-us...un-a-macro-when-certain-cells-change-in-excel

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("N:N")
    
    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