Session Eight: Forms and Macros
Download sample files for the Session Eight sample lessons|
Lesson |
Lesson |
High Res Video |
|
|---|---|---|---|
| Introduction and Objectives | [PDF] | [Video] |
 |
| Lesson 8‑1: Add group box and option button controls to a worksheet form |
 |
||
| Lesson 8‑2: Add a combo box control to a worksheet form | |||
| Lesson 8‑3: Set form control cell links | |||
| Lesson 8‑4: Connect result cells to a form | |||
| Lesson 8‑5: Add a check box control to a worksheet form | |||
| Lesson 8‑6: Use check box data in result cells | |||
| Lesson 8‑7: Add a temperature gauge chart to a form | |||
| Lesson 8‑8: Add a single input data table to a form | |||
| Lesson 8‑9: Improve form usability | [PDF] | [Video] |
|
| Lesson 8‑10: Understand macros and VBA | |||
| Lesson 8‑11: Record a macro with absolute references | [PDF] | [Video] |
|
| Lesson 8‑12: Understand macro security |
|
||
| Lesson 8‑13: Implement macro security | |||
| Lesson 8‑14: Record a macro with relative references | |||
| Lesson 8‑15: Use shapes to run macros | |||
| Lesson 8‑16: Run a macro from a button control | |||
| Session 8: Exercise | [PDF] |
|
|
| Session 8 Exercise Answers | |||