Flashcards
Macro Terminology
Cards in this deck (29)
- 1Code Windowthe window in Visual Basic Editor (VBE) that displays the Visual Basic code (commands) for a macro
- 2Commentsdocumentation located in the Visual Basic code to help clarify the purpose and meaning of the macro
- 3What do comments do within macros?comments provide information about the macro without affecting the actual execution of the macro
- 4What do comments look like in VBE?they are indicated in Visual Basic Editor with an apostrophe at the beginning of the comment, and they are color-coded green
- 5What does the F1 function key do?will retrieve help when pressed while an object, property, or method of Visual Basic code is highlighted in the Visual Basic Editor
- 6How do you access the Microsoft Visual Basic help?- click on Help while in Visual Basic Editor
- click on the Visual Basic for Applications Language Reference link to access various help topics related to using Visual Basic - 7Local Windowdisplays variables and how they change as a macro is run
- 8What is a Local Window used for?debugging (correcting errors in) a macro
- 9Where do you access the Local Window?the Local Window can be accessed under the View menu in Visual Basic Editor
- 10Methodan action that can be performed on an object (such as clearcontents, copy, delete, select, save, close, etc.)
- 11What is the general syntax for Visual Basic code involving methods?object.method(parameter value)
- 12What would the command for indicating that Excel should select cell A3 look like?Range(“A3”).Select
- 13Modulea collection of macros located in the Visual Basic Editor
- 14How do you rename a Module?modules can be renamed in the Properties Window
- 15Where can you access the Properties Window?can be accessed under the View menu in Visual Basic Editor
- 16How do you insert a new module?a new module can be added by clicking on the Insert menu in Visual Basic Editor and then clicking on Module
- 17Objectan element of the Excel Application (such as a worksheet, a cell, a range of cells, or the entire workbook)
- 18What is a macro's relation to an object?macro code is written to manipulate an object by performing an action on that object (through a method) or changing a characteristic of an object (through a property)
- 19How is the Visual Basic Code for an object written?object.property or object.method
- 20What is the object in the command Range("A3").Select?the object is Range("A3")
- 21Project Explorer Window- in this window, you can access macros you have recorded or written in modules or ThisWorkbook
- you can insert a new module or click on ThisWorkbook in the Project Explorer Window to write a new macro - 22Where is the Project Explorer Window located?on the left side of the Visual Basic Editor
- 23Propertyan attribute of an object in Excel that defines/changes one of its characteristics (such as its name, size, color, formula, value, or location)
- 24What does the Visual Basic command to change the property of an object look like?object.property=expression
- 25Which part of the command Range("A3").Font.ColorIndex=3 is the property?Font.ColorIndex=3
- 26Syntaxis the set of rules specifying how you must enter Visual Basic commands
- 27Variablea named storage location in Visual Basic Editor that contains data you can retrieve and modify while the macro code is being executed
- 28What is a variable's relation to macro code?variables are created and defined within the macro code
- 29Valueonce you create a variable and give it a value, you can assign the value to an object
Information
- Description
- Business/Economics Flashcards on Macro Terminology, created by Kennadie Long on 29/11/2018.
- Created by
- Kennadie Long
- Views
- 0
- Rating