VBA MCQs
VBA MCQs
Our experts have gathered these VBA MCQs through research, and we hope that you will be able to see how much knowledge base you have for the subject of VBAX by answering these 100+ multiple-choice questions.
Get started now by scrolling down!
1: What does VBA mean?
A. Visual Basic Answers
B. Visual By Arithmetic
C. Visual By Algorithms
D. Visual Basic for Applications
2: Using the Select Case construct is ideal when:
A. Too many if-then statements have already been used
B. An action is taken regardless of the value a variable
C. A variable is a Boolean type
D. A variable can take on multiple values
3: To obtain the value of the number of characters used in a textbox field on a form, which snippet of VBA code would you use?
A. Len(CStr(Forms!DataEntryfrm.Text11.Value))
B. Spaces(Forms!DataEntryfrm.Text11.Value)
C. Char(Forms!DataEntryfrm.Text11.Value)
D. Length(CStr(Forms!DataEntryfrm.Text11.Value))
4: How do you figure out the number of items in a collection?
A. (none of these are correct)
B. Using Items property
C. Using Count property
D. Using Ubound property
E. Using Contains method
5: Correct this statement to start a 5-iteration loop: For x = 1 to 10 Step -2
A. For x = 1 to 5 Step 2
B. For x = 1 to 10 Step 2
C. For x = 1 to 5 Step 5
D. For x = 1 to 10 Step 5
6: To save a VBA project with an Excel workbook, the workbook must be saved as what type of file?
A. xlsm
B. xlsx
C. xlv
D. xlsv
7: Which of the following do not work on Excel on Mac
A. ActiveX Controls
B. Form Controls
8: What is difference between a sub routine and a function.
A. Function can return a value.
B. Sub routine can return a value.
9: What is a macro used for?
A. To link Excel files together
B. To automatically complete a series of Excel steps
C. To create buttons and forms in Excel
D. To access programs in Excel
10: What does VBA stand for
A. Virtual Basic for Advanced programming
B. Visual Basic Applied
C. Visual Basic for Applications
D. Very Basic Applications
11: Which of the following snippets of VBA code is not a loop?
A. Select Case... Case... Case Else... End Select
B. Do Until... Loop
C. For Each.. Next
D. Do While... Loop
12: You can use VBA to connect to a database in SQL Server using:
A. Just a simple SQL statement
B. an ethernet cable
C. an ADODB.Connection
D. Access as a go-between
13: To comment a block of code, you must first:
A. Turn on Num Lock
B. Activate the Edit toolbar in the Visual Basic Editor
C. Turn on Caps Lock
D. Restart Excel
14: How do you declare the variable myvar as an integer?
A. Document myvar as an Integer
B. Dim myvar As Integer
C. Declare myvar is an Integer
15: The 'not equal to' operator is:
A. >=
B. <>
C. ==
D. <=
16: Which of the following would you begin a comment line with?
A. Double quote
B. Single quote
C. Equal sign
D. Underscore
17: On July 4, 2013, What will be displayed in the message box from the following statement: MsgBox(Format(Now,"mm-dd-yyyy"))
A. 07-04-2013
B. 7-4-2013
C. 7/4/2013
D. 07/04/2013
18: To force all variables is a VBA project to be declared, which must be stated in a module?
A. Option Explicit
B. Option Variables
C. Option Implicit
D. Option Declare
19: True or False? It is possible to name a Sub with a string containing a space.
A. False
B. True
20: True or False? Commenting at the end of a line of code is permissible.
A. True
B. False
21: To continue to run code even if a line of code causes an error, choose the VBA code to continue to the next line of code.
A. Goto
B. Next
C. On Error Resume
D. On Error Resume Next
22: What do you need to select to set the developer mode?
A. Show developer tab in the Ribbon
B. Show mini toolbar on selection
C. Show visual basic options menu
D. Show macro code settings
23: Which of the following is not a VBA data type?
A. Date
B. Integer
C. VarChar
D. Long
E. String
24: The tab order in a user form:
A. Allowing the controls to be sorted alphabetically within the user form
B. ________ is a way to control the order in which the controls are selected using the TAB key.
C. Requireing the user to assign numbers to each control on the user form
D. Arranging the worksheets in an Excel workbook
25: You've created a user form named 'Entry_Form'. To make the user form appear, use which of the following statements?
A. Entry_Form.Appear
B. UserForm.Entry_Form.Run
C. UserForm.Load
D. Entry_Form.Show
26: The shortcut keystroke to open the VBA IDE is:
A. F10
B. Alt+F11
C. Alt+Ctrl+F8
D. Alt+V
27: Choose the VBA code that will allow you to obtain information about an error.
A. Err.Type
B. Err.Description
C. Err.Title
D. Err.Name
28: Is it possible to create an array with the lowerbound being two?
A. Sometimes
B. No
C. Yes
29: Which of these is not a Visual Basic object?
A. Sheets
B. Range
C. Selection
D. FontSize
30: Declaring a public variable allows the user to..
A. Use the variable anywhere in Excel
B. Use the variable as a named range in Excel
C. Use the variable only within the module in which the variable was declared
D. Use the variable anywhere in the project in which the variable was declared
31: What does a VBA macro consist of?
A. User instructions and Excel functions
B. Computer code that performs some actions on or with objects
C. Macro instructions that direct the user application and provide help to the user
D. Excel functions
32: The RowSource property of a Combo Box control allows the user to:
A. control where the output of selected item should go
B. define the list of items, from a range of cells, to appear in a drop-down list
C. have only one item in the drop-down list
D. restrict which row of cells can be the source of input items for the drop-down list
33: Which worksheet event can be used to run a procedure upon deleting the contents of a cell?
A. Click
B. Calculate
C. Change
D. Activate
34: In the statement x = "4" + "5"', x = ?
A. 1
B. 9
C. -1
D. 45
35: What is the shortcut keystroke to debug VBA code one line at a time?
A. F5
B. Alt+F5
C. F8
D. Ctrl+F8
36: The way to pass the latest values of variables between functions and procedures is identified as:
A. (none of these)
B. ByRef
C. ByUpdate
D. ByChange
37: Which of the following VBA windows shows the code of the active object?
A. Properties window
B. Code window
C. Immediate window
D. Explorer Window
38: Which of these statements will start a loop of exactly 20 iterations?
A. For i = 1 to 21
B. For i = 2 to 40
C. For i = 2 to 22
D. For i = 2 to 40 Step 2
39: Dim a,b as integer What is the type of a?
A. variant
B. integer
40: The statement 'Dim a, b as Single' declares the variables a and b as what variable types?
A. a as Double, b as Single
B. a as Single; b as Single
C. a as Double; b as Double
D. a as Variant; b as Single
41: If you want to create a definition for a custom object in VBA, which of the following would be the best choice to insert into your project?
A. Class Module
B. Module
C. UserForm
D. Procedure
42: What is the property of a cell that allows you to set the font color of the contents?
A. Cell.Color
B. Font.Color
C. FontColor
D. CellColor
43: Which of the following functions do not perform a calculation
A. IPmt
B. Exp
C. Sqr
D. Val
44: What does the DoEvents do?
A. Allows operation system to process other events
B. Runs all events (built-in or custom) in a vb project
C. Declare a new event that can be fired from code
D. Runs all Excel events in a vb project
45: Choose the VBA code that switches control from the application to the OS.
A. Wait
B. Goto
C. DoEvents
D. Continue
46: Which of the following actions will NOT cause a macro to run in Excel?
A. Add a new worksheet
B. Open a workbook
C. (all of these will NOT cause a macro to run in Excel)
D. Click on a picture
47: What is the difference between activating and initializing a user form?
A. Activate will always run when showing a user form whereas Initialize will only run when showing a user form that has not been stored in memory.
B. There are no differences. Both are run whenever a user form is shown.
C. There are differences only if Option Explicit is stated.
D. Initialize will always run when showing a user form whereas Activate will only run when showing a user form that has not been stored in memory.
48: To change a comment in cell A1, which will do the job?
A. Range("A1").Comment.Text("My Comment")
B. Range("A1").Comment("My Comment")
C. Range("A1") = "My Comment"
D. Range("A1").Text("My Comment")
49: Combine into one line: If x > 5 Then y = x - 5 End If
A. y = x - 5 If x > 5
B. If x > 5 Then y = x - 5
C. If x > 5, y = x - 5
D. If x > 5 Then y = x - 5 End If
50: To change the text displayed in a label on a form, choose the VBA code that will allow you to update the property.
A. Me.Label3.Value = "Hello"
B. Me.Label3.Caption = "Hello"
C. Me.Label3 = "Hello"
D. Me.Label3.Text = "Hello"
List of VBA MCQs Multiple Choi...
Available in:
VBA MCQs
Вопросы VBA на русском языке
Preguntas de VBA en idiomas españoles
日本語での VBA の質問
Domande VBA in lingua italiana
Questions VBA en langues françaises
Questões VBA em Língua Portuguesa
VBA-Fragen in deutschen Sprachen
中文（简体）语言的 VBA 问题
أسئلة VBA باللغات العربية
Soal VBA bahasa Indonesia
Türk dillerinde VBA soruları
