PROGRAMMING WITH VBA - Practice Mode

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

Mid() Chr() ASC() Instr()

Correct Answer: Instr()

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

Static Private Public Protect

Correct Answer: Public

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

2 3 4 6

Correct Answer: 4

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

Project scope Local scope Global scope Module scope

Correct Answer: Module scope

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

Local scope Module scope Global scope Project scope

Correct Answer: Local scope

Back to Question Sets Next Question Set

Try Another Topic

Try Another Quiz