+ Reply to Thread
Results 1 to 5 of 5

Need VBA expression

  1. #1
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Smile Need VBA expression

    There is a one word vba expression that allows code execution to continue elsewhere in the project. I can't remember the expression. Can anyone remember?
    Turn Data into Information
    Turn Information into Knowledge
    Turn Knowledge into Direction
    Turn Direction into Leadership
    Turn Leadership into Results
    Stephen Druley

    It's not how quickly you think
    But how deeply you think
    The quality of thinking is measured
    by remoteness to conformance
    Stephen Druley

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Need VBA expression

    are you thinking something like this

    if(condition is satgisfied) goto nextstep
    (nextstep is only an example)

    some where below there should be a statement

    nexstep:
    (note colon at the end of nextstep)

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Need VBA expression

    Quote Originally Posted by SDruley View Post
    There is a one word vba expression that allows code execution to continue elsewhere in the project. I can't remember the expression. Can anyone remember?
    That is a very sketchy description of what you need.
    Please Login or Register  to view this content.
    means that if an error is encountered, the code will resume execution on the line following the line that caused the error.
    Please Login or Register  to view this content.
    causes the code to immediately jump from the GoTo line to the lablename: line (almost always a bad idea).
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Need VBA expression

    You mean DoEvents?
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Re: Need VBA expression

    DoEvents is correct

+ 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