Results 1 to 3 of 3

Cant get of H9 changes to 5 only triggers the other triggers as well

Threaded View

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007 to 2013
    Posts
    35

    Cant get of H9 changes to 5 only triggers the other triggers as well

    Hi,

    Ive got this to work in sequence but ideally id like these as separate macro to trigger only if "h9" changes for example.

    ANy assistance greatly appreciated.

    Private Sub Worksheet_Change(ByVal Target As Range)
    
    If Range("E9").Value = 5 Then CongratsEmail_1
    If Range("E9").Value <> 5 Then
    End If
    
    If Range("H9").Value = 5 Then CongratsEmail_1
    If Range("H9").Value <> 5 Then
    End If
    
    If Range("K9").Value = 5 Then CongratsEmail_1
    If Range("K9").Value <> 5 Then
    End If
    
    If Range("N9").Value = 5 Then CongratsEmail_1
    If Range("N9").Value <> 5 Then
    End If
    
    If Range("Q9").Value = 5 Then CongratsEmail_1
    If Range("Q9").Value <> 5 Then
    End If
    
    End Sub
    Last edited by alansidman; 07-04-2023 at 05:42 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sickness tracker with triggers
    By OurMaz in forum Excel General
    Replies: 1
    Last Post: 05-10-2023, 07:14 PM
  2. [SOLVED] Triggers
    By donwb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2015, 12:10 PM
  3. Event Triggers
    By CapstanJD in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2014, 03:14 PM
  4. Date Triggers
    By trainer102 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2014, 07:48 AM
  5. How to use triggers
    By Shilpa kanchan in forum Excel General
    Replies: 2
    Last Post: 07-29-2012, 11:29 AM
  6. help! trouble with triggers...
    By macromaiden in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2006, 01:13 PM
  7. [SOLVED] Event Triggers
    By MVM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2005, 11:05 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