PROGRAMMING WITH VBA - Quiz

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

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

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

Static Private Public Protect

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

2 3 4 6

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

Project scope Local scope Global scope Module scope

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

Local scope Module scope Global scope Project scope