Automating Applications with Visual Basic

1. Automating Applications with Visual Basic Chapter 11 - Review

2. Review A _________ is a VBA procedure that performs a particular task or returns a result. macro function A VBA ___________ is a procedure that returns a result similar to Excel’s built-in functions. Excel’s _______ _____ Workbook is a workbook that automatically loads whenever you load any Excel workbook. Personal Macro

3. Review Excel saves macros in a special object called a _________, which is stored with the workbook. Module button You can assign a macro to a ______ to facilitate running the macro by those unaccustomed to using Excel commands. module A __________ is where Excel stores VBA code.

4. Review A ________ contains forms, modules, and the Excel workbook objects. Project Iteration (loop) You can use a _____________ or repetition structure to repeat a series of VBA instructions. The instruction that makes a decision to do one action or another is called a __________ structure. selection

5. Review You can pass a cell reference to a custom function through one of its __________. arguments Excel stores in a _______ all macros and user-defined functions. module Store a macro in Excel’s ________ ______ workbook to make it available to any workbook you open. Personal Macro

6. Review A variable’s ______ ______ restricts the type of information it holds. data type You pass a cell reference to a sub procedure or a function through a(n) __________. argument A _______ is an action that takes place on behalf of the object to which it is attached. method

7. Review The _________ statement is the first line of a function or sub procedure definition. prototype Buttons you add to an Excel worksheet to launch sub procedures normally do not appear on printouts. Why not? Buttons are designed for on-screen use, and they are convenient for worksheet users. By default, buttons do not display on a printed worksheet because users cannot interact with printed buttons.

8. Review You can create a macro by using the Macro Recorder or by creating it yourself in the Visual Basic Editor. Using the Macro Recorder is usually a simpler way to create a macro. Why would you use the Visual Basic Editor to create a sub procedure? You cannot use the macro recorder to create a sub procedure that repetitively executes a series of instructions. Another feature that the macro recorder is incapable of recording is branching. By writing your own sub procedures, or subroutines, you can take advantage of the full power of VBA and break the limits imposed by using the macro recorder alone.

9. Review What is the main difference between a sub procedure and a user-defined (custom) function? A sub procedure contains VBA statements that that affect a worksheet or workbook. A custom function cannot delete a worksheet column, format worksheet cells, insert a worksheet, or perform an action that alters a workbook. Unlike a sub procedure, a custom function can only return a value to a worksheet formula. Why does Excel display a warning dialog box when you open a workbook containing macros? To warn you of the potential viruses that can be hidden in macro instructions.