Code excecution interrupted error using InputBox

**NBVC** · 06-15-2009, 02:01 PM

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:

Please Login or Register  to view this content.

Highlighting the

Please Login or Register  to view this content.

part..

what gives?

I am entering the info as I always did and click Ok on my inputbox.

**DonkeyOte** · 06-15-2009, 02:08 PM

A complete reboot may resolve... ?

**NBVC** · 06-15-2009, 02:10 PM

of Excel or the PC?

I rebooted Excel.. but to no avail.

**DonkeyOte** · 06-15-2009, 02:11 PM

nope, complete system reboot...

**NBVC** · 06-15-2009, 02:16 PM

Ok, I will give it ago and report back.

**NBVC** · 06-15-2009, 02:20 PM

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

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

**DonkeyOte** · 06-15-2009, 02:32 PM

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

**NBVC** · 06-15-2009, 02:40 PM

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

**shg** · 06-15-2009, 02:49 PM

You should press Cancel and see if the sub really exits.

**NBVC** · 06-15-2009, 02:56 PM

Originally Posted by shg

You should press Cancel and see if the sub really exits.

Sorry, thought you said exists...

Yes, it does exit as intended.

**shg** · 06-15-2009, 03:02 PM

Ah -- you have Option Compare Text.

Re: Code excecution interrupted error using InputBox