VBA applies logic behind the scenes. Files Must be saved as macro-enabled workbooks (.xlsm as opposed to .xlsx) Enable macros by selecting Center→Trust Center Settings→ →File→Options→Trust Macro Settings Definitions correspond to nouns, Objects properties correspond to adjectives, correspond to methods verbs, and correspond to adverbs. arguments (these are plural) contain all Collection objects individual objects of a certain type Help (<F2>) Object Browser Lists all objects, properties, and methods The Visual Basic Editor (VBE) The VBE is the programming workspace. It’s easy to toggle back and forth (<ALT>< F11>) between the Excel worksheets and the VBE.
VBA applies logic behind the scenes. Files Must be saved as macro-enabled workbooks (.xlsm as opposed to .xlsx) Enable macros by selecting →File→Options→Trust Center→Trust Center Settings→ Macro Settings Definitions Objects correspond to nouns, properties correspond to adjectives, methods correspond to verbs, and arguments correspond to adverbs. Collection objects (these are plural) contain all individual objects of a certain type Help Object Browser (<F2>) Lists all objects, properties, and methods The Visual Basic Editor (VBE) The VBE is the programming workspace. It’s easy to toggle back and forth (<ALT>< F11>) between the Excel worksheets and the VBE.
MgtOp-556-Topic-1-Set-1.docx