PROGRAMMING WITH VBA - Quiz

1) Where does Excel come in object hierarchy of VBA?

Range object Workbook object Worksheet object Application object

2) Which shortcut key is used to open project explorer window in VBA?

Ctrl + R Ctrl + P Ctrl + W Ctrl + E

3) Which shortcut key is used to open VBA Editor from the Excel worksheet?

Ctrl + F11 Alt + F11 Ctrl + V Ctrl + F7

4) What is the Full form of IDE?

Integrated Development Element Internal Development Environment Integrated Development Environment Internal Distributed Environment

5) Which shortcut key is used to step into line - by - line execution in VBA?

F2 F4 F5 F8