Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA SETTINGS - WHAT THEY DO WITH DIFFERENT ERRORS?
Hi,
I would like to know what does different settings gotta do with scripts, like 1. Tools - Option - General - Break on All Errors 2. Tools - Option - General - Break on Unhandled Errors I have one script not working when MSVB(xl) was on option 2. Then I had another script not working when MSVB(xl) was on option 1. Do I have to change the options each time for each code OR code to bypass/change/check the options first & do something. Thx. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA SETTINGS - WHAT THEY DO WITH DIFFERENT ERRORS?
If you set it to break on all errors, then it will pause for every error that
occurs during the course of the procedure running, even though the error has a handler because it will not check to see if it is handled first. If you set it to break on unhandled errors, then when an error with a handler occurs, it just keeps on truckin. But if there is no handler, it will pause so you can fix the cause of the error or step into the next line of code, if you don't want to fix the cause of the error. But it will give you the opportunity to to do something. I have mine set to break on unhandled errors because I dont want to be bothered with the ones that I already know about and have built-in remedies for. "Sinner" wrote: Hi, I would like to know what does different settings gotta do with scripts, like 1. Tools - Option - General - Break on All Errors 2. Tools - Option - General - Break on Unhandled Errors I have one script not working when MSVB(xl) was on option 2. Then I had another script not working when MSVB(xl) was on option 1. Do I have to change the options each time for each code OR code to bypass/change/check the options first & do something. Thx. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA SETTINGS - WHAT THEY DO WITH DIFFERENT ERRORS?
On Sep 27, 2:39*am, JLGWhiz wrote:
If you set it to break on all errors, then it will pause for every error that occurs during the course of the procedure running, even though the error has a handler because it will not check to see if it is handled first. If you set it to break on unhandled errors, then when an error with a handler occurs, it just keeps on truckin. *But if there is no handler, it will pause so you can fix the cause of the error or step into the next line of code, if you don't want to fix the cause of the error. *But it will give you the opportunity to to do something. I have mine set to break on unhandled errors because I dont want to be bothered with the ones that I already know about and have built-in remedies for. "Sinner" wrote: Hi, I would like to know what does different settings gotta do with scripts, like 1. Tools - Option - General - Break on All Errors 2. Tools - Option - General - Break on Unhandled Errors I have one script not working when MSVB(xl) was on option 2. Then I had another script not working when MSVB(xl) was on option 1. Do I have to change the options each time for each code OR code to bypass/change/check the options first & do something. Thx.- Hide quoted text - - Show quoted text - so thats what was happening... Yippee : D i understand now Thanks... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My page settings changed and won't reset (print settings) | Excel Programming | |||
ControlSource Property Throwing Errors After Changing Regional Settings | Excel Programming | |||
Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
Add to Settings.txt | Excel Programming |