Macro & VBA Flashcards

1
Q

A set of instructions that execute a sequence of commands to automate repetitive or routine tasks

A

Macro

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What’s used to create a macro (2)

A

Macro recorder

Visual Basic for Application (VBA)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Where can you find Macro

A

View tab

Developer Tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

A robust programming language that can be used in various software packages to enhance and automate functionality

A

VBA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

A file in which macros are stored

A

Module

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

An application used to create, edit, execute and debug macros using programming language

A

Visual Basic Editor (alt + F11)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

A procedure or macro always begin and end with the

A

Sub and End Sub statements

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

These are in green and provide information about the macro but do not affect its execution

A

Comments

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

These are in blue and they are special syntax that have special meaning

A

Keywords

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Two types of VBA macros

A

Sub procedures

Custom functions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Perform actions on a workbook, like clear form or insert current date in a worksheet; created when using the macro recorder

A

Sub procedures

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Similar to other built-in functions in Excel; manipulate input variables and return a value

A

Custom functions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

A container for text

A

Label

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Allows the user to type text

A

TextBox

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

A drop down list

A

ComboBox

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Allows user to select an item from a list

A

ListBox

17
Q

A clickable button

A

CommanButton

18
Q

Allows the user to specify a value by dragging a bar

A

ScrollBar

19
Q

Allows the user to specify a value by clicking up or down

A

SpinButton

20
Q

Allows the user to select from multiple options

A

OptionButton

21
Q

Customized dialog boxes that allow us to type in data

A

UserForms