MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

keyboard problem

  Asked By: Trupti    Date: Aug 23    Category: MS Office    Views: 1496

While running a macro/vba routine, tested on 7 computers, all dell, some with
usb keyboards, a couple with ps-2 keyboards and one that is a ps-2 converted to
usb. on 3 of the computers CTRL + Break does not break and eventually causes the
routine to error randomly (different subroutines, different lines, no apparrent
patter other than the debugger stops)....

Anyone have any idea on this? The dedicated computer to run this routine seems
to be the worst victim of the errors. all are running USB 2.0, i'm stumped...




4 Answers Found

Answer #1    Answered By: Adalwolfa Fischer     Answered On: Aug 23

You have listed the various keyboard  types but haven't said whether there is
any pattern between keyboard type and successful break.

Try using Escape to do the break. It might work more reliably.

Answer #2    Answered By: Rebekah Walker     Answered On: Aug 23

there really isn't a successful patter between keyboard  type and success...
only one computer  (mine but i'm not really one who's to use this.. i'm just
trying to trouble shoot it is the only one that is successful with all the
keyboard types)... some work with the usb  others with the ps-2..... i'll
suggest/try the escape key to see if that works....

Answer #3    Answered By: Fadwa Ahmed     Answered On: Aug 23

I don't have an answer for the CTRL + Break situation, but I am
wondering why this is a concern at all?! Why are you relying on this
method to stop a program? From my point of view it is incorrect, and
clearly unreliable.

Answer #4    Answered By: Bin Fischer     Answered On: Aug 23

well the Escape key seems to work... as for why we are needing this... it's a
temp fix for an occasional endless loop that occurs due to certain information
input incorrectly (not on our end but on some db query info that we connect to)
that we haven't been able (so far) to handle error  wise....

Didn't find what you were looking for? Find more on keyboard problem Or get search suggestion and latest updates.