Programming With Vba Set 1

---

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

  

    (A) Mid()

    (B) Chr()

    (C) ASC()

    (D) Instr()

Instr()

---

Which keyword is used to declare the variables in project scope

  

    (A) Static

    (B) Private

    (C) Public

    (D) Protect

Public

---

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

  

    (A) 2

    (B) 3

    (C) 4

    (D) 6

2

---

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

  

    (A) Project scope

    (B) Local scope

    (C) Global scope

    (D) Module scope

Module scope

---

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

  

    (A) Local scope

    (B) Module scope

    (C) Global scope

    (D) Project scope

Local scope

---