Lesson 4 - Overview of Student Grading Spreadsheet (Part 1 of 3)
Overview of Student Grading Spreadsheet (Part 1 of 3)
We'll examine a spreadsheet application that brings together three tools you learned about recently:
- Module 8 - Named Ranges
- Module 9 - Excel Tables
- Module 10 - VBA Arrays
The Part 1 video is 9 minutes and covers:
- Overview - What you can expect to see in the spreadsheet
- Walk-through - How a user would use the spreadsheet to see what it accomplishes
- Structure - We see a flow diagram explaining how the worksheets and subroutines work together
- VBA Project - We look at each part of the VBA project and focus on the "Control" module because it has the top level subroutines to control code execution
- Naming Subroutines - We use names like Click_Protect() to make it easier to assign macros to buttons on the worksheet
Write your comments and feedback below
- If you have questions or comments about this lesson, write it in the section below.
- Alternatively you can email the instructor Victor at [email protected]
0 comments