BMGT302 - VBA

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/65

encourage image

There's no tags or description

Looks like no tags are added yet.

66 Terms

1
New cards

What does VBA stand for?

Visual Basic for Applications.

2
New cards

What is VBA?

Microsoft's programmatic way to automate operations in its applications.

3
New cards

Which applications are mentioned as supporting VBA?

Excel, Access, Word, PowerPoint, and Outlook.

4
New cards

What language is VBA derived from?

Visual BASIC (Visual Beginner's All-purpose Symbolic Instruction Code).

5
New cards

Are VB and VBA the same?

No. VBA is a subset of the functionality available in VB.

6
New cards

Fill in the blank: VB is a ______ programming language.

standalone

7
New cards

Fill in the blank: VBA is primarily used with ______ software packages.

application

8
New cards

What does it mean that Excel exposes its object model to VBA?

VBA can manipulate Excel's objects.

9
New cards

What is a macro language?

A language capable of automating sequences of commands in spreadsheet or word-processing applications.

10
New cards

What is a macro?

An action or set of actions that can run as many times as needed.

11
New cards

What kinds of tasks can VBA automate?

Recurring tasks and repetitive tasks; macros can also run based on events.

12
New cards

What can VBA create for worksheets?

Custom worksheet functions.

13
New cards

What file extension is used for Excel files without VBA code?

.xlsx

14
New cards

What file extension is used for Excel files with VBA code?

.xlsm

15
New cards

Why can VBA files be dangerous?

VBA code can contain viruses.

16
New cards

What should you know before opening an .xlsm file?

Know and trust the source.

17
New cards

What does a trusted location allow?

Macro-enabled files in that folder or its subfolders open without a macro-enabling warning.

18
New cards

Which Excel tab is enabled to access VBA tools?

Developer tab.

19
New cards

What does VBE stand for?

Visual Basic Editor.

20
New cards

What is the Visual Basic Editor?

An integrated development environment where programmed instructions are maintained.

21
New cards

What does IDE stand for?

Integrated development environment.

22
New cards

What is an IDE?

A software application suite consolidating tools to write and test software.

23
New cards

Which shortcut opens the VBE?

Alt + F11.

24
New cards

What is the Immediate Window used for?

Issuing one-line VBA commands.

25
New cards

What is a line of code?

A logic statement that performs a portion of a task.

26
New cards

What is a macro also called on the terminology slide?

A function, subroutine, or procedure.

27
New cards

What is a module?

A container to organize code.

28
New cards

What is a project in the VBE?

A group of all modules, forms, and other programming elements.

29
New cards

How many projects are there per workbook according to the slide?

One.

30
New cards

Which module handles workbook-level events?

Workbook Module.

31
New cards

Which module contains code tied to worksheet events?

Worksheet Module.

32
New cards

Which module holds programmer-created or recorded macros?

Standard Module.

33
New cards

Which module provides dialogs for user input?

UserForm Module.

34
New cards

Which module allows programmers to create customized objects?

Class Module.

35
New cards

What is an example of a worksheet event?

Selecting a range or entering a value in a cell.

36
New cards

What are examples of UserForm controls?

Buttons, list boxes, and checkboxes.

37
New cards

Where do you change a module's name?

The Name property in the Properties Window.

38
New cards

What must a module name start with?

A letter.

39
New cards

What is the maximum module-name length stated in the slides?

255 characters.

40
New cards

Name characters prohibited in a module name.

Spaces, periods, exclamation marks, @, &, $, and #.

41
New cards

Can reserved words be used as module names?

No.

42
New cards

What is the Object Browser for?

Browsing all available objects in a project.

43
New cards

What shortcut opens the Object Browser?

F2.

44
New cards

Which key displays a macro's code?

F7.

45
New cards

How can module code be protected from viewing?

Lock the code with a password, required after saving and reopening.

46
New cards

What file format is used for the Hello World workbook?

.xlsm

47
New cards

Which key executes a macro in the VBE?

F5.

48
New cards

What button can execute a macro from a worksheet?

A button assigned to the macro.

49
New cards

Fill in the blank: All VBA macros start with ______.

Sub

50
New cards

What does Sub mean?

Subroutine.

51
New cards

How does a VBA comment begin?

An apostrophe (').

52
New cards

Are VBA comments executed?

No.

53
New cards

What color are VBA comments in the editor?

Green.

54
New cards

What color are VBA keywords in the editor?

Blue.

55
New cards

What color indicates a syntax-error line after Enter?

Red.

56
New cards

What does pressing F1 do in the VBE?

Opens help documentation.

57
New cards

What is IntelliSense?

VBE hints and automatic completion for code.

58
New cards

What can IntelliSense add after typing a Sub declaration?

Parentheses and an End Sub line.

59
New cards

What can IntelliSense list for objects?

Properties and methods.

60
New cards

What can IntelliSense list for methods?

Arguments.

61
New cards

Which shortcut helps autocomplete a variable name?

Ctrl + Space.

62
New cards

What does Dim do in the course example?

Declares variables.

63
New cards

What does InputBox do in the car-sales example?

Asks the user to enter a sales cutoff.

64
New cards

What does MsgBox do in the car-sales example?

Displays a message reporting the result.

65
New cards

Fill in the blank: The example uses a ______ loop to repeat checks.

For

66
New cards

What does a Run button help end users avoid?

Having to use the VBE directly.