Racing Rectangles and Excel VBA

1st macro programming project for Excel spreadsheets has been assigned. It was handed out in late August or early September during the 1st or 2nd week of class, but that was a very simple version.

• See the November 12th, 2001 user interface for the racing rectangles game. Has the extra feature of allowing celebrating a victory to be turned on of off.

• Pausing without using the Timer function can be done by Windows sleep API instead.

• See the user interface for the racing rectangles game. All rectangles are in the starting blocks.

• Handout from September of 2001, simplest version of racing rectangles. YOU ARE NOT TO DO THIS SIMPLE VERSION, except perhaps as a warmup to prepare yourself for the real project.

• See another user interface snapshot, the exciting finish of the one of the races. The finish line dancing rectangle touchdown celebration is NOT shown.

• See the RaceEm macro code for the Visual Basic for Applications (VBA) program. You have this on a handout, but the Photoshop annotations are useful to see and study here.

• See the ResetRace macro, as well as the pauseDelayAmt() macro. The screen snapshots of the VBA code window are annotated with Photoshop graphics, so they should be helpful to study. You have this code on your handout.

• Due date: by Monday, September 11th at the start of class.