Closed Thread
Results 1 to 2 of 2

Detect change in cell with formula

Hybrid View

  1. #1
    Registered User
    Join Date
    03-23-2004
    Posts
    10

    Angry Detect change in cell with formula

    I have a cell which is changing constantly. I need to detect when that specific cell changes. I know I can use Worksheet_Change event to detect that; the problem is that this event does not detect when the change is in a cell with a formula (or at least not that I know). This specific cell has a formula. So how can I capture that?
    Thanks!

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,565

    Detect change in cell with formula

    Hi,

    Say the formula is in cell A1, its' result is 10 and any other value will result in the cell shading changing to red, try the following code within the Worksheet_Change event for the relevant sheet:

    If Range("A1").Value = 10 Then
            Range("A1").Interior.ColorIndex = xlNone
        Else
            Range("A1").Interior.ColorIndex = 3 'Red
        End If
    Hope this helps.

    Kind regards,

    Robert

Closed Thread

Thread Information

Users Browsing this Thread

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

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