EXCEL PROJECT 7

Using Macros and Visual Basic
for Applications (VBA) with Excel

Objectives

Use the Undo button to undo multiple changes Use passwords to assign protected and unprotected status to a workbook Use the macro recorder to create a macro Execute a macro Understand Visual Basic for Applications code Customize a toolbar by adding a button Customize a menu by adding a command

Add controls to a worksheet, such as command buttons, scroll bars, check boxes, and spin buttons Assign properties to controls Use VBA to write a procedure to automate data entry into a worksheet Understand Do-While and If-Then-Else statements Test and validate incoming data Explain event-driven programs

TERMS FOR EXCEL PROJECT 7

1. procedure 2. program code 3. execute 4. visual basic for applications (vba) 5. macro recorder 6. macro 7. password 8. workbook protection 9. macro names 10. visual basic editor 11. user interface 12. application

13. design mode 14. run mode 15. desk checking 16. comments 17. private 18. public 19. end sub statement 20. function 21. object 22. spin button 23. loop 24. variable

ASSIGNMENTS

Recording a Macro and Assigning It to a Toolbar Button and Menu Command pp. 7.10-7.25 1) Review common functions already used in past projects. 2) Introduce new financial functions and concepts. 3) Class follows demo recording a Macro to print a worksheet in landscape using the fit to option. 4) Class assigns the Macro to a toolbar button and the menu command 5) CompleteApply Your Knowledge p. 7.74 5) Work on vocabulary definitions as presented in class. November 6-9 Creating a Procedure to Automate Data Entry pp.7.25-7.41 1) Class follows demo Creating an Adjustment Center pp. 7.41-7.71 1) Class follows demo

Creating an Adjustment Center pp. 7.41-7.71 1) Class follows demo Additional exercises 1) Complete Learn It Online activities for review 2) Complete Practice Test located in the Handout Folder Tentative Test Date for Project 7 is Wednesday November 21