Macro Examples
Written Macro Assignment
True/False Questions. Read each statement carefully, and neatly write the word TRUE on the line next to the statement if you believe the statement is true, or neatly write the word FALSE on the line next to the statement if you believe the statement is false.
______T____ 1. Do…Loops are used in macros to repeat lines of code until or while a specified condition is met.
_______F___ 2. The area where macro code is displayed in Visual Basic is called the Project Explorer Window.
_______F___ 3. A macro name is not required when creating a private macro.
__________ 4. When declaring a variable, Dim stands for “declare in macro”.
__________ 5. Objects, Attributes, Variables, and Methods are used to write macro code.
__________ 6. One way to create a new macro is to use the Macro Wizard.
__________ 7. The If…Then…Else…End If code allows code to be conditionally executed depending on whether a specified logical condition has been met.
__________ 8. The last line of code for a private macro should be End Sub.
__________ 9. The formula for a user-defined function must be entered in quotation marks.
__________ 10. A public macro/procedure is also known as an activation procedure, because it is activated by the user pressing the shortcut keys or clicking on a button.
Problems. Read each problem carefully and follow the instructions given.
1. Open up Excel. Go to Cell E9 and use the Name Box to name this cell “Summer”. Then go to the Developer tab on the Ribbon, and click on the Record Macro button in the Code group. Name your macro “Referencing” and give it a shortcut key of “R”. After clicking OK to close the Record Macro dialog box, do the following:
• Select Cell D11 using absolute referencing (do not select the Use Relative Reference button). •
True/False Questions. Read each statement carefully, and neatly write the word TRUE on the line next to the statement if you believe the statement is true, or neatly write the word FALSE on the line next to the statement if you believe the statement is false.
______T____ 1. Do…Loops are used in macros to repeat lines of code until or while a specified condition is met.
_______F___ 2. The area where macro code is displayed in Visual Basic is called the Project Explorer Window.
_______F___ 3. A macro name is not required when creating a private macro.
__________ 4. When declaring a variable, Dim stands for “declare in macro”.
__________ 5. Objects, Attributes, Variables, and Methods are used to write macro code.
__________ 6. One way to create a new macro is to use the Macro Wizard.
__________ 7. The If…Then…Else…End If code allows code to be conditionally executed depending on whether a specified logical condition has been met.
__________ 8. The last line of code for a private macro should be End Sub.
__________ 9. The formula for a user-defined function must be entered in quotation marks.
__________ 10. A public macro/procedure is also known as an activation procedure, because it is activated by the user pressing the shortcut keys or clicking on a button.
Problems. Read each problem carefully and follow the instructions given.
1. Open up Excel. Go to Cell E9 and use the Name Box to name this cell “Summer”. Then go to the Developer tab on the Ribbon, and click on the Record Macro button in the Code group. Name your macro “Referencing” and give it a shortcut key of “R”. After clicking OK to close the Record Macro dialog box, do the following:
• Select Cell D11 using absolute referencing (do not select the Use Relative Reference button). •