Excel 2016 Macros

Excel 2016

Lesson 1 - Using Macros

Steps

Practice Data

5. Select the Developer check box. 6. The option is selected. 7. Select OK . The Excel Options dialog box closes and the Developer tab appears on the Ribbon .

Click

Developer to

select it

Click

8. Select the Developer tab. Developer tab is displayed.

Click Developer

O PENING THE V ISUAL B ASIC E DITOR W INDOW  D ISCUSSION

Excel macros are written in the Visual Basic for Applications (VBA) programming language. Macros are saved in modules, which in turn are saved in the worksheet in which the macros were written. Modules cannot be viewed in the normal window view; they can only be displayed in the Visual Basic Editor window. You can create, edit, view and run macros from this window.

The Visual Basic Editor window houses several task panes and windows. The Project Explorer is displayed at the top-left of the work area; it displays the various Microsoft Excel Objects and Modules in a tree format. The tree can be expanded or collapsed in much the same way as files and folders are expanded or collapsed in Windows Explorer.

The Properties Window is displayed at the bottom-left of the work area. It shows the properties of the Microsoft Excel Object or Module that is currently selected in the Project Explorer.

Both the Project Explorer and the Properties Window are task panes and can be dragged to any position within the Visual Basic Editor window or docked against any side of the window.

One or more Code windows may be displayed to the right of the Project Explorer and Properties Window task panes. Code windows display the programming code attached to a Microsoft Excel Object or Module. For example, when a Module Code window is displayed, all the details of your macros are displayed including the macro name, description, keyboard shortcut, macro code and any additional comments. In the Code window, you can view, edit, write and run macros. Code windows can be moved, resized, minimized or maximized within the Visual Basic Editor window.

You can open the Code window for any Object or Module by double-clicking its name in the Project Explorer.

OFFICEPRO, Inc.

Page 21