+ Reply to Thread
Results 1 to 10 of 10

Macro modification - Trigger for pop up reminder

  1. #1
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Macro modification - Trigger for pop up reminder

    Solved for some reason the original post info was removed?
    Last edited by SVTF; 10-26-2014 at 10:13 PM.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Macro modification - Trigger for pop up reminder

    I am assuming that when you say you are "selecting" you are actually changing the value within a drop down box such as a data validation list. Otherwise you would need to use Worksheet_SelectionChange rather than Worksheet_Change for what you are asking. The reason it is happening twice is because of the range of scope: If Intersect(Target, Range("G:G,I:I")).

    The original code accounted for this by requireing both G and I to pass a "True" test prior to executing more code: If Cells(r, "G") = "Yes" And Not IsDate(Cells(r, 9))
    By removing the one piece you only need to have the "True" test pass for column G.

    To answer your question, based upon what appears to be your procedure, you would need to write a more complex if statement which accounted for the new variables you are introducing or just leave things the way they are and change your procedure back to the initial way. This might do it for you but could easily be prone to problems:

    Please Login or Register  to view this content.

  3. #3
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,309

    Re: Macro modification - Trigger for pop up reminder

    @SVTF

    did this work you?

    if it didn't can you upload the file so I can test a few things....thanks
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  4. #4
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Re: Macro modification - Trigger for pop up reminder

    @judgeh59 - the suggestion code by @stnkynts created a run time error.

    I am at work as soon as I get home I will upload a version - Thanks.

  5. #5
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Macro modification - Trigger for pop up reminder

    All I did was change the IsDate to IsEmpty. I doubt that is what is causing the error

  6. #6
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Re: Macro modification - Trigger for pop up reminder

    Figured this part out.
    Last edited by SVTF; 10-26-2014 at 10:14 PM.

  7. #7
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Re: Macro modification - Trigger for pop up reminder

    Anyone able to assist on this in case @judgeh59 does not chime in today.

    See post above for tweaks.

    Hoping to get this done for tomorrow.

    Thanks in advance.

  8. #8
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Macro modification - Trigger for pop up reminder

    Hello SVTF,

    Try this out and let me know it works for you.

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  9. #9
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Re: Macro modification - Trigger for pop up reminder

    @Leith Ross - No go.

    Pop up did not come up when I selected N/A in G

    Yes worked.
    No worked for < 14 days
    No did not work for > 14 days - pop up to change No to Yes did not come up.

  10. #10
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Re: Macro modification - Trigger for pop up reminder

    I think I figured it out - I modified the original code.

    I removed the GoTo Finished from the N/A code section ... seems to be working testing now.

    Please Login or Register  to view this content.

+ 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. Adjust a code from cell range trigger to button trigger
    By ld2x07 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2014, 10:02 AM
  2. Excel 2007 : Macro modification
    By Martin Chamberlin in forum Excel General
    Replies: 1
    Last Post: 10-04-2011, 03:51 AM
  3. Macro Modification
    By johncena in forum Excel General
    Replies: 1
    Last Post: 02-16-2010, 01:10 AM
  4. Macro Modification
    By CranialBlaze in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-15-2009, 05:17 AM
  5. Replies: 0
    Last Post: 03-13-2006, 07:15 PM

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