VBA Flashcards
1
Q
VBA Requires
A
Developer Option
2
Q
Developer Option
A
- File
- Options
- Customized Ribbon
- Go to Developer and Click it
3
Q
Visual Basic Ribbon
A
Alt+F11
4
Q
VBA
A
- Visual Basic for Applications
2. Procedures are Written
5
Q
Module
A
Creates Code
6
Q
Run Macros through Module
A
On the Sheet Which is Open
7
Q
F5
A
Run Code
8
Q
F8
A
Debugging: Step By Step
9
Q
Body of Code
A
Sub Name and Then Enter
10
Q
Range
A
- Cell Reference e.g. “A1:A6”
- Cells e.g Cells (), Cells ()
- Range Name e.g. “myrange”
11
Q
Variable x
A
e.g. x=1
12
Q
Stop
A
- Write Stop
2. Click on Grey Area on the Left Side of the Code
13
Q
For
A
x=1 to 10
14
Q
Next
A
x
15
Q
Date
A
Function
