+ Reply to Thread
Results 1 to 6 of 6

VBA code that auto-runs when a cell value changes to a specific value due to a formula?

  1. #1
    Registered User
    Join Date
    03-16-2018
    Location
    Wichita, KS
    MS-Off Ver
    2016
    Posts
    3

    VBA code that auto-runs when a cell value changes to a specific value due to a formula?

    Hello! I'm having a little trouble figuring out how to get this to run based on a formula vs a manual output.

    Right now, this works and sends an email if I manually input "PAST DUE". However, there is a formula that changes the cell value to "PAST DUE" and I want the macro to run automatically whenever the formula changes the cell to "PAST DUE" (from "NOT YET DUE").

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: VBA code that auto-runs when a cell value changes to a specific value due to a formula

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: VBA code that auto-runs when a cell value changes to a specific value due to a formula

    .
    Paste this macro into the worksheet module that has the cell in question :

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    03-16-2018
    Location
    Wichita, KS
    MS-Off Ver
    2016
    Posts
    3

    Re: VBA code that auto-runs when a cell value changes to a specific value due to a formula

    Ok, I think I attached it.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-16-2018
    Location
    Wichita, KS
    MS-Off Ver
    2016
    Posts
    3

    Re: VBA code that auto-runs when a cell value changes to a specific value due to a formula

    I should edit "EmailNotice"?

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: VBA code that auto-runs when a cell value changes to a specific value due to a formula

    .

    Mail_with_outlook2

    In the first macro edit : If Target.Address = "$H$3" Then ' edit the $H$3 to correspond to the cell that changes in your project.
    Last edited by Logit; 03-16-2018 at 05:40 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. [SOLVED] Macro code that runs despite specific cells being locked.
    By TBM in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 01-26-2016, 08:56 PM
  2. Using Worksheet_SelectionChange, so code only runs when specific cells are changed
    By Kristine T. in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-20-2015, 08:49 PM
  3. VBA that runs when cell within range is changed to specific value
    By KT99 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-24-2014, 12:07 PM
  4. InStr function doesn't find specific text, but finds any text in column and runs code
    By mikey3580 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2014, 03:50 AM
  5. Auto-Run Macro to Specific Cell when Target is a Formula
    By kyleheney in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2013, 02:33 PM
  6. Macro runs when i click on specific cell
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-19-2009, 05:28 AM
  7. Code runs only if a specific page of the MultiPage is selected
    By Gabor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-18-2009, 07:18 PM

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