Lesson Plan : Excel - Macros, with simple VBA
Teacher Name: | Mohit Jindal |
Grade: | Grade 7-8 |
Subject: | Other |
Topic: | How to create Macro in Microsoft Excel |
Content: | function of Alt+F8/F11 command How to write in module |
Goals: | how to open a dialog box with message |
Objectives: | Open a dialog box with a message |
Materials: | Excel, Some background knowledge |
Introduction: | Visual Basic Editor is a program within Excel that allows you to communicate with Excel. |
Development: | Create a simple excel file, insert module and do coding in the dialog box which appear |
Practice: | Create a file in excel using macro VBA individually |
Accommodations: | Use key Alt+F11 to create a module and Alt+F8 to run the module |
Checking For Understanding: | Make all students create their own module with student number pop up |
Closure: | Students can save time by automating common commands |
Evaluation: | |
Teacher Reflections: |
| Create New Lesson Plan | Lesson Plan Center |