In general laymen terms, we can say that, On Error Resume Next enables the error handler and On Error GoTo 0 disables the error handler under VBA. On the other side, “On Error GoTo 0” will disable this effect caused by Resume Next and again enable the error window to pop-up as soon as there is an error at the time of debugging. “On Error Resume Next” is an error-handling method which neglects the error and then moves to the next line of code execution (this is one sort of error handling rule defined in VBA). We ideally use two error handling methods in VBA. In VBA as well we have certain rules which are defined to handle the errors. Every programming language has certain rules defined for error handling. Error handling is something that has the utmost importance under any programming language and the programmer is expected to know different rules that can be used for error handling. In this article, we will see an outline on VBA On Error GoTo 0.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |