Types of programming errors

Building a macro and getting it to run isn't the end of the development process. The programmer must ensure the macro does the job it is meant to do. This requires testing and - if the macro doesn't run correctly - fixing the errors (bugs). This is called debugging. Sometimes macros will pass the tests, and sometimes they will fail. Test failure is extremely common in a software developer's life irrespective of their skills and experience. It is the exception rather than the rule that a program runs correctly first time. A substantial amount of a software developer' s life is spent finding and correcting errors in programs.

Programming errors fall into three categories in VBA. They are syntax errors, run-time errors and logical errors

0 0

Post a comment