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()

Explanation:

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

Explanation:

Visual Basic (VB) Access Modifiers (Public, Private, Protected, Friend) In visual basic, Access Modifiers are the keywords and those are useful to define an accessibility level for all the types and type members.

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

Previous Question Set Back to Question Sets Next Question Set

Try Another Topic

Try Another Quiz