This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Chapter 13: Part 1 - I nt roduction to Visual Basic for Applications (and Working with Macros in Excel) Learning Objectives • Add the Developer tab to the Excel ribbon to access the VBA programming environment. • Record a macro and save it in the active/current workbook • Save a macro in your Personal Macro Workbook • Run a recorded macro from: the macro utility the Visual Basic Editor (the VBA programming environment) worksheet controls Quick Access Toolbar a workbook event • Learn how to launch the Visual Basic Editor, and navigate between Excel and VBA • Examine and modify macro code using the Visual Basic Editor • Understand the R1C1 reference style in Excel and VBA • Document VBA code using code “comments” (programmer's notes) Vocabulary Term Definition Macro A group of VBA statements that can be reused to perform a particular task in Excel. “Macro” usually refers to recorded actions of the user, but the term is commonly used interchangeably with procedure , subroutine procedure , subroutine , or sub (see definition below). A macro may be recorded in Excel or it may be coded by the programmer directly in VBA. Recorded macros can be altered (code added, modified, or deleted) by the VBA programmer. VBA "Module" An Excel object where macros (or other VBA code blocks) are saved. A new module is created automatically when a new macro session is initiated. Personal Macro Workbook A workbook that Excel always loads, and subsequently hides (in the Excel view), whenever you launch Excel. The workbook is created automatically the first time a user selects the option to store a macro in the “Personal Macro Workbook.” 1 VBA Project The Excel file itself that contains forms, VBA modules, and Excel modules (Sheet modules, ThisWorkbook module). R1C1 Reference Style Cell reference style in which both columns and rows are identified by numbers. (Contrast with A1 reference style in which columns are identified by letters.) The R1C1 style is especially useful in specifying relative or absolute cell positions in VBA code in terms of row and column indices (as integers). (See how to change to this option on page 539 of your textbook. VBA procedure (Also called macro , subroutine procedure , subroutine , or sub ) A procedure can be recorded as a macro, or be written directly in a module using the VBA programming language. VBA function A function that is already available in VBA, or a function written by a programmer (user-defined function), that may be used within an Excel workbook or a VBA module. Works like an Excel function in that it may require arguments and returns a value....
View Full Document
This note was uploaded on 08/15/2011 for the course ACIS 2504 at Virginia Tech.