VBA

Question 1

VBA Requires

Answer 1

Developer Option

Question 2

Developer Option

Answer 2

1. File
2. Options
3. Customized Ribbon
4. Go to Developer and Click it

Question 3

Visual Basic Ribbon

Answer 3

Alt+F11

Question 4

VBA

Answer 4

1. Visual Basic for Applications

2. Procedures are Written

Question 5

Module

Answer 5

Creates Code

Question 6

Run Macros through Module

Answer 6

On the Sheet Which is Open

Question 7

F5

Answer 7

Run Code

Question 8

F8

Answer 8

Debugging: Step By Step

Question 9

Body of Code

Answer 9

Sub Name and Then Enter

Question 10

Range

Answer 10

1. Cell Reference e.g. “A1:A6”
2. Cells e.g Cells (), Cells ()
3. Range Name e.g. “myrange”

Question 11

Variable x

Answer 11

e.g. x=1

Question 12

Stop

Answer 12

1. Write Stop

2. Click on Grey Area on the Left Side of the Code

Question 13

For

Answer 13

x=1 to 10

Question 14

Next

Answer 14

x

Question 15

Date

Answer 15

Function

Question 16

If

Answer 16

Then and End If

Question 17

Else

Answer 17

Within Above Loop

Question 18

Values Can Also Be

Answer 18

False and True

E.g. Cells (3,2)= False