acct 628 unit p
Terms
undefined, object
copy deck
- keywords
- items that appear in blue are _, which are words Excel recognizes as part of the VBA programming language
- visual basic editor
- to view vba code, you open the _, which contains a project window, a properties window, and a coe window
- debug
- when you locate the error, you can then correct, or _ it
- main procedure
- the resutling procedure,, which process (or runs) multiple procedures in sequence, is referred to as a _
- project exploerer, code window, roperties window
- you view and edit modules in the visual basic editor, which is made up of 3 windows: _, _ , and _
- declares
- irst part of code, dim x as x _ or defines
- letter
- variable names in vba must begin with a _. _ can be uppercase or lowercase
- function
- predefined procedure that returns (creates and displays) a value
- module
- the visual basic equivalent of a worksheet. in it you store macro procedures, just as you store data in worksheets
- syntax
- when writing visual basic code for ecel, you must follow the formatting rules, or ), of the vba programming language
- bug
- when a macro procedure doesnt rn properly, it can be due to an error, referred to as a _
- comments
- notes explaining the code; they're displayed in green, and the remaining code is displayed in black
- autocomplete
- to assist you in entering the vba code, the editor uses ) a list of words that can be used in the macro statement and match what is typed
- 255
- variable names can't include periods or spaces and can be up to # characters long
- arguments
- variables used by other procedures which the main procedure might run
- project
- collection of all procedures in a workbook
- procedure header
- the first line of a procedure, called the _ _, defines the procedure's type, name, and arguments