Accounting > STUDY GUIDE > ACCOUNTANC 2258Exam 3 Study Guide (filled out) (All)

ACCOUNTANC 2258Exam 3 Study Guide (filled out)

Document Content and Description Below

Accountancy 2258 Exam 3 Study Guide 1. Macros a. Be familiar with ALL terminology defined in the Macro Review Materials.doc file. Macro: a series of commands, actions, and functions that can be s ... tored and initiated (run) whenever you want to perform a particular task. Visual Basic for Applications(VBA): refers to a programming language you can use to create macros. Visual Basic Editor (VBE): embedded within Excel and can be accessed through the Developer tab. Visual Basic Commands: are the steps of the macro that define the macro’s functionality. “Macro Code” Code Window: the window in the Visual Basic Editor (VBE) that displays the Visual Basic code (commands) for a macro. Comments: documentation located in the Visual Basic code to help clarify the purpose and meaning of a macro. Local Window: displays variables and how they change as a macro is run Method: action that can be performed on an object (such as clearcontents, copy, delete, select, save, close, etc.) Module: a collection of macros located in the Visual Basic Editor. You can place several macros in one module or create new modules for each individual macro. Object: an element of the Excel Application (such as a worksheet, cell, range of cells, or entire workbook). Property: an attribute of an object in Excel that defines/changes one of its characteristics (such as its name, size, color, formula, value, or location). Syntax: the set of rules specifying how you must enter Visual Basic commands. Variable: a named storage location in Visual Basic Editor that contains data you can retrieve and modify while the macro code is being executed. b. Understand how to use Active X Controls – combo box, spin button, scroll bar, option buttons, and check boxes – and know why/when each of these would be used. c. Know the major components of the Visual Basic Editor and what each is used for – Project Explorer window, Code window, comments (in green), VBA instructions/code, Modules, and ThisWorkbook. d. VBA macros (procedures) – what they are and why they are used [Show More]

Last updated: 3 years ago

Preview 1 out of 5 pages

Buy Now

Instant download

We Accept: