Powerful PowerPoint for Educators

Using Visual Basic for Application to Make PowerPoint Interactive

by David M. Marcovitz

Examples by Chapter
Chapter 11

Examples by Chapter Home | Chapter 6 | Chapter 7 | Chapter 8 | Chapter 9 | Chapter 10 | Chapter 11 | Chapter 12

Click on a an example to download it. These examples will not run over the Web, they will not run with the PowerPoint Viewer, they will not run while compressed, and they will not run with macros disabled.

Note that this chapter is about debugging so many of the examples below do not work (intentionally). They are designed to demonstrate different debugging techniques as described in Chapter 11.

# Pages from Book Description Zip Version Text Version
11 217-245 All examples from Chapter 11 Chapter11.zip
(203KB)
 
11.1 223-224 AddStar procedure with bugs and msgBox commands to help find the bugs. Example11-01.zip
(35KB)
Example11-01.txt
(1KB)
11.2 225 AddStar procedure with bugs to demonstrate how commenting out might help. Example11-02.zip
(35KB)
Example11-02.txt
(1KB)
11.3 233 Indenting - This example has a large nested If statement that works but is hard to understand because not use any indenting. Example11-03.zip
(39KB)
Example11-03.txt
(1KB)
11.4 240-243 Error Trapping - This example uses error trapping techniques so the VBA will continue working even when there is an error and report some information about the error. This example writes the results of a quiz to a file and skips writing to the file if, for example, the file cannot be written because the user doesn't have write privileges, and continues by setting everything up for the printable slide. Note that Mac users have to change the \ to : in the Open statement (as described in Chapter 10). Example11-04.zip
(54KB)
Example11-04.txt
(5KB)
11.5 244 Exercise to Try with Bad Indenting - This example from the Exercises to Try section has a complex nested If structure without any indenting making it very difficult to understand. Try to figure out what will happen before running the code. Example11-05.zip
(42KB)
Example11-05.txt
(1KB)
11.6 245 Exercise to Try with Four Errors - This example from the Exercises to Try section has four bugs. Use the debugging techniques from Chapter 11 to try to find all of them. Example11-06.zip
(48KB)
Example11-06.txt
(1KB)

Examples by Chapter Home | Chapter 6 | Chapter 7 | Chapter 8 | Chapter 9 | Chapter 10 | Chapter 11 | Chapter 12


This page was created by Dr. David M. Marcovitz.
Last updated: May 14, 2012