Programming with VBA MCQ with Answers

Programming with VBA MCQ with Answers

1) Which VBA built in function returns location at the second string occurs within the first string?

Answer is:

Instr()

Explanation:

.

2) Which keyword is used to declare the variables in project scope

Answer is:

Public

3) In VBA, How many types of access specifiers available in VBA?

Answer is:

2

4) Which type of variable cannot be declared within a procedure in VBA?

Answer is:

Module scope

5) Which variable recognized only within the procedure in which it is declared?

Answer is:

Local scope