I have been using thinkorswim RTD for excel. Everything works well, except I like to get some sort of pop up notification if RTD data in a cell changes. I found some simple code off the web, it works for regular data change but not for RTD. It can't detect RTD changes with below code. Any ideas without doing something too complicated?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$I$17" Then
MsgBox Target.Value & " " & Target.Offset(0, 1).Value
End If
End Sub
Bookmarks