Automating Tasks with VBA (Visual Basic for Applications) MCQs

1. What does VBA stand for in MS Office?
(A) Visual Basic for Applications
(B) Virtual Basic for Access
(C) Visual Binary for Automation
(D) Variable Based Architecture

2. Where can you access the VBA editor in MS Office applications like Excel or Word?
(A) File → Options → Add-ins
(B) Insert → Object
(C) View → Macros
(D) Developer Tab → Visual Basic

3. In VBA, which keyword is used to define a procedure that performs actions but does not return a value?
(A) Function
(B) Sub
(C) Dim
(D) Return

4. What is the purpose of the “Dim” statement in VBA?
(A) To define a module
(B) To execute a macro
(C) To declare variables
(D) To terminate a loop

5. Which VBA object is used to represent the entire Excel application?
(A) Workbook
(B) Application
(C) Worksheet
(D) Range

6. What is the shortcut key to open the VBA editor in MS Office?
(A) Alt + F11
(B) Alt + F8
(C) Ctrl + F5
(D) Shift + F2

7. In VBA, which loop continues to execute as long as a condition is true?
(A) For…Next Loop
(B) Select Case
(C) If…Then Statement
(D) Do While Loop

8. What is a macro in the context of VBA?
(A) A recorded or written set of instructions that automates tasks
(B) A worksheet function
(C) A style format
(D) A type of chart

9. Which VBA function is used to display a message box to the user?
(A) PrintBox
(B) MsgBox
(C) ShowText
(D) DialogBox

10. Why might you use VBA instead of just recording a macro?
(A) To enable printing shortcuts
(B) To reduce file size only
(C) To change the document theme
(D) To create more complex, customized, and flexible automation