|
Subject:
|
UserForms "locking up"
|
|
Posted By:
|
Joss
|
Post Date:
|
1/6/2004 10:54:45 PM
|
I have a recurring problem with a workbook containing a number of userforms. The workbook seems to "lock up" or hang at various points with no error displayed. When I go to Ctrl-Alt-Del to kill the task I get a message "Cannot Quit microsoft excel". If I then wait another 5 secs or so another window pops-up and allows me to "end now" - with a message that "microsoft excel is busy or waiting for and input". Which it isn't!!!
HELP!!!
|
|
Reply By:
|
c90232a
|
Reply Date:
|
1/10/2004 9:42:10 PM
|
Run the macro from the VBA ide. When the program seems to lock up hit <CTRL><BREAK>, the program will stop, the VBA ide will pop up with the the cursor in the section of code containing the error.
Hopefully you'll be able to see the problem, once you know where it is. Use some break points, etc.
Hard to comment on the actual problem without a peek at the code - perhaps you could post the offending routine here?
Regards,
td
|
