+ Reply to Thread
Results 1 to 11 of 11

Code excecution interrupted error using InputBox

Hybrid View

  1. #1
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Code excecution interrupted error using InputBox

    I have been using a specific macro for at least 2 years now without incident...

    but today for some reason I am get an error:

    Code Execution has been interrupted
    and it breaks at this point in the code:

      ProjectID = UCase(Application.InputBox(Prompt:="Enter a Project Number (and Release, if desired)", Title:="Project"))
        If ProjectID = "False" Then Exit Sub
    Highlighting the
    If ProjectID = "False" Then Exit Sub
    part..

    what gives?

    I am entering the info as I always did and click Ok on my inputbox.
    Last edited by NBVC; 06-15-2009 at 02:29 PM.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Code excecution interrupted error using InputBox

    A complete reboot may resolve... ?

  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Code excecution interrupted error using InputBox

    of Excel or the PC?

    I rebooted Excel.. but to no avail.

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Code excecution interrupted error using InputBox

    nope, complete system reboot...

  5. #5
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Code excecution interrupted error using InputBox

    Ok, I will give it ago and report back.

  6. #6
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Code excecution interrupted error using InputBox

    Wouldn't you know it, that worked...

    Is this explicable or is it just one of those things?

  7. #7
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Code excecution interrupted error using InputBox

    It appears to normally stem from using CTRL + BREAK to interrupt a routine...

  8. #8
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Code excecution interrupted error using InputBox

    Although I never did use that key combination... I just ran as normal.

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

    Re: Code excecution interrupted error using InputBox

    You should press Cancel and see if the sub really exits.
    Entia non sunt multiplicanda sine necessitate

  10. #10
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Code excecution interrupted error using InputBox

    Quote Originally Posted by shg View Post
    You should press Cancel and see if the sub really exits.
    Sorry, thought you said exists...

    Yes, it does exit as intended.

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

    Re: Code excecution interrupted error using InputBox

    Ah -- you have Option Compare Text.

+ 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