1/65
Looks like no tags are added yet.
What does VBA stand for?
Visual Basic for Applications.
What is VBA?
Microsoft's programmatic way to automate operations in its applications.
Which applications are mentioned as supporting VBA?
Excel, Access, Word, PowerPoint, and Outlook.
What language is VBA derived from?
Visual BASIC (Visual Beginner's All-purpose Symbolic Instruction Code).
Are VB and VBA the same?
No. VBA is a subset of the functionality available in VB.
Fill in the blank: VB is a ______ programming language.
standalone
Fill in the blank: VBA is primarily used with ______ software packages.
application
What does it mean that Excel exposes its object model to VBA?
VBA can manipulate Excel's objects.
What is a macro language?
A language capable of automating sequences of commands in spreadsheet or word-processing applications.
What is a macro?
An action or set of actions that can run as many times as needed.
What kinds of tasks can VBA automate?
Recurring tasks and repetitive tasks; macros can also run based on events.
What can VBA create for worksheets?
Custom worksheet functions.
What file extension is used for Excel files without VBA code?
.xlsx
What file extension is used for Excel files with VBA code?
.xlsm
Why can VBA files be dangerous?
VBA code can contain viruses.
What should you know before opening an .xlsm file?
Know and trust the source.
What does a trusted location allow?
Macro-enabled files in that folder or its subfolders open without a macro-enabling warning.
Which Excel tab is enabled to access VBA tools?
Developer tab.
What does VBE stand for?
Visual Basic Editor.
What is the Visual Basic Editor?
An integrated development environment where programmed instructions are maintained.
What does IDE stand for?
Integrated development environment.
What is an IDE?
A software application suite consolidating tools to write and test software.
Which shortcut opens the VBE?
Alt + F11.
What is the Immediate Window used for?
Issuing one-line VBA commands.
What is a line of code?
A logic statement that performs a portion of a task.
What is a macro also called on the terminology slide?
A function, subroutine, or procedure.
What is a module?
A container to organize code.
What is a project in the VBE?
A group of all modules, forms, and other programming elements.
How many projects are there per workbook according to the slide?
One.
Which module handles workbook-level events?
Workbook Module.
Which module contains code tied to worksheet events?
Worksheet Module.
Which module holds programmer-created or recorded macros?
Standard Module.
Which module provides dialogs for user input?
UserForm Module.
Which module allows programmers to create customized objects?
Class Module.
What is an example of a worksheet event?
Selecting a range or entering a value in a cell.
What are examples of UserForm controls?
Buttons, list boxes, and checkboxes.
Where do you change a module's name?
The Name property in the Properties Window.
What must a module name start with?
A letter.
What is the maximum module-name length stated in the slides?
255 characters.
Name characters prohibited in a module name.
Spaces, periods, exclamation marks, @, &, $, and #.
Can reserved words be used as module names?
No.
What is the Object Browser for?
Browsing all available objects in a project.
What shortcut opens the Object Browser?
F2.
Which key displays a macro's code?
F7.
How can module code be protected from viewing?
Lock the code with a password, required after saving and reopening.
What file format is used for the Hello World workbook?
.xlsm
Which key executes a macro in the VBE?
F5.
What button can execute a macro from a worksheet?
A button assigned to the macro.
Fill in the blank: All VBA macros start with ______.
Sub
What does Sub mean?
Subroutine.
How does a VBA comment begin?
An apostrophe (').
Are VBA comments executed?
No.
What color are VBA comments in the editor?
Green.
What color are VBA keywords in the editor?
Blue.
What color indicates a syntax-error line after Enter?
Red.
What does pressing F1 do in the VBE?
Opens help documentation.
What is IntelliSense?
VBE hints and automatic completion for code.
What can IntelliSense add after typing a Sub declaration?
Parentheses and an End Sub line.
What can IntelliSense list for objects?
Properties and methods.
What can IntelliSense list for methods?
Arguments.
Which shortcut helps autocomplete a variable name?
Ctrl + Space.
What does Dim do in the course example?
Declares variables.
What does InputBox do in the car-sales example?
Asks the user to enter a sales cutoff.
What does MsgBox do in the car-sales example?
Displays a message reporting the result.
Fill in the blank: The example uses a ______ loop to repeat checks.
For
What does a Run button help end users avoid?
Having to use the VBE directly.