+ Reply to Thread
Results 1 to 5 of 5

Excel RTD, needs a pop up if data updates

  1. #1
    Registered User
    Join Date
    06-14-2023
    Location
    Austin, tX
    MS-Off Ver
    2016
    Posts
    6

    Excel RTD, needs a pop up if data updates

    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

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,946

    Re: Excel RTD, needs a pop up if data updates

    You can set up a range to store values so that there is something to compare the new value to when the cell(s) is (are) updated. For example, if column Z is not used, and the RTD data is in cells B2:B10:

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    06-14-2023
    Location
    Austin, tX
    MS-Off Ver
    2016
    Posts
    6

    Re: Excel RTD, needs a pop up if data updates

    Quote Originally Posted by Bernie Deitrick View Post
    You can set up a range to store values so that there is something to compare the new value to when the cell(s) is (are) updated. For example, if column Z is not used, and the RTD data is in cells B2:B10:

    Please Login or Register  to view this content.
    Thank you so much! It worked so well that I couldn't stop the pop up from popping up! lol.

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,946

    Re: Excel RTD, needs a pop up if data updates

    If you want to control the pop-up, change this line:

    Please Login or Register  to view this content.
    to something like this, where D3 can be either Yes or No:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-14-2023
    Location
    Austin, tX
    MS-Off Ver
    2016
    Posts
    6

    Re: Excel RTD, needs a pop up if data updates

    Never mind, it did make a sound, windows 11 beep sound was so low, I couldn't hear it. Thanks.



    "Have you tried to make a beep sound with excel before? I have found an example online and put keyword 'Beep' inside the if statement but doesn't appear to be doing anything."
    Last edited by flybuzz; 09-28-2023 at 04:05 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create an Org Chart that Automatically Updates from Excel Data
    By mfreund21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2019, 03:57 PM
  2. [SOLVED] Excel graph with offset formula so it updates with data is add
    By TAMMY32 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-24-2016, 02:51 PM
  3. Data updates in Sheet2 when there are updates in sheet1
    By pal004 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2014, 10:20 AM
  4. VBA: Excel form that updates current data on the same worksheet
    By justinp in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-29-2011, 09:37 AM
  5. VBA: Excel form that updates current data or add new data
    By jadown in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-18-2011, 05:18 AM
  6. Replies: 3
    Last Post: 03-04-2011, 06:01 AM
  7. [SOLVED] Is Excel good for storing data that constantly updates?
    By Lallo in forum Excel General
    Replies: 2
    Last Post: 12-15-2005, 08:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1