VBA and Macros Flashcards
1
Q
within the “visual basic editor”, execute macro
A
F5
2
Q
open “visual basic editor” OR toggle between Excel and “visual basic editor” once opened
A
Alt + F11
3
Q
display the “macro” dialog box
A
Alt + F8
4
Q
expand the “insert form controls” and “active x controls” drop-down menu
A
Alt + L + I
5
Q
record macro
A
Alt + W + M + R
6
Q
use relative references
A
Alt + W + M + U
7
Q
display the “immediate window” in the “visual basic editor”
A
Ctrl + G
8
Q
within the “visual basic editor”, display the “object browser”
A
F2
