+ Reply to Thread
Results 1 to 3 of 3

preventing with if statement

  1. #1
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    preventing with if statement

    Hello friends,

    I have a workbook and at some point i want to save data. all i want is to abort the operation or continue with IF. i'm stuck, could you help me, please?
    any help is really appreciated.
    here is my code
    Please Login or Register  to view this content.
    john
    Last edited by john55; 12-24-2010 at 06:27 AM.

  2. #2
    Registered User
    Join Date
    12-18-2010
    Location
    UK
    MS-Off Ver
    2003, 2007, 2010
    Posts
    79

    Re: preventing with if statement

    Would this approach work?

    Have a macro that does the IF work and use that to determine when your existing code should run.
    Please Login or Register  to view this content.
    Last edited by BigDat6CC; 12-24-2010 at 04:26 AM. Reason: Tidying up code
    David
    Access and Excel Developer | UK

  3. #3
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: preventing with if statement

    hi BigDat6CC,

    yesss! it's working! thanks a lor for your help!
    (the code is from this forum, I'm sorry that I do not remember the owner's name.)

    john
    Marry Christmas to all!
    Last edited by john55; 12-24-2010 at 06:29 AM.

+ Reply to 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