Lecture-16(debugg) - Debugging and Error Trapping What is a...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Debugging and Error Trapping
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
What is a bug? An error that prevents the program from executing as intended. Can be of the form: Syntax errors: violations of the rules of language such as due to mis-spellings of program statements, illegal ways in which numbers are formed Execution errors: occur when a syntax-error- free program is executed - sometimes called run-time error - e.g. Division by zero
Background image of page 2
Types of errors Logic errors: most difficult errors to spot, since program apparently will execute and produce results, however results may be absurd because of faulty logic - no errors will be reported by the diagnostics
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
VBA Help Help invoked using Menu selection
Background image of page 4
Help Menu Help sought on this topic using Index
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Context Sensitive Help Place the cursor anywhere on the word or syntax for which you need help and press the key F1
Background image of page 6
Passive debugging Get Error when you press Run The Debug option breaks the execution of the code, you are transferred back to the code and to the line where you have the error The value of the variable is displayed
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 13

Lecture-16(debugg) - Debugging and Error Trapping What is a...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online