In this Post we discussed 100 VBA MCQ (Multiple Choice MCQs) with answers.
- In VBA, _______ are used to declare every variable before it is used.
A) Option implicit
B) Option explicit
C) Main implement
D) Main termination
Correct Answer: B) Option explicit
2) In VBA, a combo box is formed by combining:
A) Label & text box
B) List box & text box
C) Button & text box
D) Label & input box
Correct Answer: B) List box & text box
3) VBA responds to events using _.
A) Text procedure
B) Object procedure
C) Event procedure
D) Code burner
Correct Answer: C) Event procedure
4) _ bytes are required for a single data type in VBA.
A) 2
B) 4
C) 8
D) 1
Correct Answer: B) 4 (assuming the data type in question is Long)
5) Which VBA statement is used to exit out of an if-else structure prematurely?
A. Break
B. Continue
C. Exit For
D. Exit If
Correct Answer: D) Exit If
6) Which VBA control is used to embed a Microsoft Excel worksheet within a user form?
A. TextBox
B. ComboBox
C. ListBox
D. Spreadsheet
Correct Answer: D) Spreadsheet
7) Which VBA function is used to convert a string to lowercase?
A. LCase()
B. UCase()
C. Lower()
D. StringToLower()
Correct Answer: A) LCase()
8) Which event is triggered when a cell value changes in Excel using VBA?
A. Worksheet_Activate
B. Worksheet_Deactivate
C. Worksheet_Change
D. Workbook_Open
Correct Answer: C) Worksheet_Change
9) Which VBA method is used to retrieve the index of the selected item in a combo box control?
A. GetIndex()
B. SelectedIndex()
C. GetCurrent()
D. Index()
Correct Answer: B) SelectedIndex()
10) Which VBA loop structure allows you to explicitly skip the current iteration and move to the next iteration?
A. For Loop
B. Do While Loop
C. Do Until Loop
D. Continue For
Correct Answer: D) Continue For
100+ MCQs on VBA(Visual Basic for Application) With Answer
11) Which operator is used to perform a logical OR operation in VBA if-else statements?
A. ||
B. &&
C. |
D. &
Correct Answer: C) |
12) Which method is used to activate a specific worksheet in Excel using VBA?
A. ActivateSheet
B. SelectSheet
C. SetActiveSheet
D. Worksheets.Activate
Correct Answer: D) Worksheets.Activate
13) Which VBA method is used to add items to a combo box control?
A. AddItem()
B. InsertItem()
C. AppendItem()
D. PopulateItem()
Correct Answer: A) AddItem()
14) Which VBA method is used to add items to a combo box control?
A. AddItem()
B. InsertItem()
C. AppendItem()
D. PopulateItem()
Correct Answer: A) AddItem()
15) Which VBA method is used to check or uncheck a checkbox control?
A. SetChecked()
B. ToggleCheck()
C. CheckState()
D. Value()
Correct Answer: D) Value()
16) Which VBA control is used to display text that the user cannot edit?
A. TextBox
B. ComboBox
C. Label
D. ListBox
Correct Answer: C) Label
17) Which of the following Office applications does not support VBA?
A. Microsoft Excel
B. Microsoft Word
C. Microsoft PowerPoint
D. Microsoft Access
Correct Answer: D) Microsoft Access (Note: Microsoft Access does support VBA, so the correct answer here should be considered incorrect if looking for applications not supporting VBA. In this case, all listed applications support VBA. For a different scenario or question, the correct answer may vary.)
18) Which VBA method is used to toggle the state of a checkbox control?
A. ToggleState()
B. SwitchState()
C. ChangeState()
D. Value()
Correct Answer: D) Value()
19) Which VBA control is used to display formatted text or numeric data in a fixed-width font?
A. TextBox
B. ComboBox
C. ListBox
D. Label
Correct Answer: D) Label
20) What does VBA stand for?
A) Visual Basic for Applications
B) Visual Basic Advanced
C) Visual Basic for Access
D) Virtual Basic for Applications
Correct Answer: A) Visual Basic for Applications
21) Who developed VBA?
A) IBM
B) Google
C) Microsoft Corp.
D) Apple Inc.
Correct Answer: C) Microsoft Corp.
22) Which of the following is NOT a Microsoft Office application that integrates VBA?
A) Word
B) Excel
C) Access
D) Photoshop
Correct Answer: D) Photoshop
23) In which major software suite is VBA integrated?
A) Adobe Creative Suite
B) Microsoft Office
C) Oracle Suite
D) LibreOffice
Correct Answer: B) Microsoft Office
VBA MCQ Questions | VBA Mock Test
24) VBA is categorized as which type of programming language?
A) Object-oriented
B) Functional
C) Procedural
D) Declarative
Correct Answer: C) Procedural
25) Which of the following is NOT mentioned as an application that VBA is integrated into?
A) Word
B) Excel
C) PowerPoint
D) Access
Correct Answer: C) PowerPoint
26) VBA was developed by which corporation?
A) IBM
B) Microsoft
C) Apple
D) Oracle
Correct Answer: B) Microsoft
27) What type of programming environment is VBA associated with?
A) Web development
B) Office automation
C) Game development
D) System programming
Correct Answer: B) Office automation