CE En 270 - Virtual Lecture

CE EN 270 - Virtual Lecture
Norm Jones	Brigham Young University

Working with Excel Events

Instructions: Click on each of the links below, in order. You will need a Shockwave-enabled browser in order to view the lectures. As you view the lecture, use the controls at the bottom of the image to pause, stop, fast-forward, and rewind the lecture. These lectures contain audio. If you are viewing the lectures in a CAEDM lab, you will need to use a set of headphones to avoid disturbing your fellow students.

Sections	Description
Intro	Introduction to events.
Task #1	In-class task #1: Writing code for the Open and Close events for a workbook.
Change Event	Change event vs. Calculate event. Checking on the target. Preventing infinite loops.
Task #2	In-class task #2: Changing the landfill example so that the calculations are automatically executed in response to control click events and worksheet change events.
Task #3	In-class task #3: Changing the chart_update spreadsheet to remove the button and cause the chart to be automatically updated whenever the value of the numpts cell is modified.