Excel VBA Programming For Dummies by Dick Kusleika

Author:Dick Kusleika [Kusleika, Dick]
Language: eng
Format: epub
ISBN: 9781119843092
Publisher: Wiley
Published: 2021-12-29T00:00:00+00:00

If this setting is selected, Excel essentially ignores any On Error statements. You normally want to keep the Error Trapping options set to Break on Unhandled Errors.

Trapping errors with the On Error statement

Using an On Error statement in your VBA code allows you to bypass Excel’s built-in error handling and use your own error-handling code. In the EnterSquareRoot5 example from the previous section, a runtime error causes the macro execution to jump to the statement labeled BadEntry. As a result, you avoid Excel’s unfriendly error messages and can display your own message to the user.

Notice that the example uses an Exit Sub statement right before the BadEntry label. This statement is necessary because you don’t want to execute the error-handling code if an error does not occur.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.