VBA MCQ questions and answers. Microsoft Excel Visual Basic for application macros objective type multiple choice question answer with pdf for computer related all competitive exams. Helpful for COPA, CCC, Gate etc.
VBA MCQ Questions and Answers
- Which VBA built in function returns location at the second string occurs within the first string?
2. Which keyword is used to declare the variables in project scope?
3.In VBA, How many types of access specifiers available in VBA?
4. Which type of variable cannot be declared within a procedure in VBA?
A Project scope
B Local scope
C Global scope
D Module scope
5. Which variable recognized only within the procedure in which it is declared?
A Local scope
B Module scope
C Global scope
D Project scope
6.How many levels of variable scope available in VBA?
7.What will be the output of the following VBA code?
B Sun, Jan01, 2017
D Sunday, January 01, 2017
8.Which function returns true if the expression is a valid date, otherwise it returns false in VBA?
9.Which function returns the day of the month (number from 1 to 31) given date value in VBA?
D Date part()
10.Which color of dot indicate the breakpoint in VBA?
11.Which shortcut key is used to set the properties of form while designing?
B Ctrl + F4
C Alt + F4
D Shift + F4
12.Which shortcut key is used to open code window in VBA?
B Alt + F7
C Ctrl + F7
D Shift + F7
13.Which code is used to display a user form in VBA?
A Load user Form1
B User Form1.Show
C User Form1.Show False
D User Form1.Load
14.Which character is to be suffixed for long data type in VBA?
15. How many numeric data types available in Excel VBA?
16.What is the another name for keywords in VBA?
C User defined words
D Reserved words
17.Which key word is used to declare the variable in VBA?
18.Which entitie hold data in VBA?
20.Which worksheet method is used to copy a sheet to another location in the workbook?
C Save AS
21.Which VBA worksheet property return or sets a string value that represents the object name?
22.Which method displays the data form associated with the worksheet in VBA?
C Show Data Form
23. Which VBA property returns a range object that represents all the cells on the worksheet?
24.Which object is member of the workbook?
25.Which type of work book method cannot be modified in VBA?
C Save AS
26.Which workbook property returns the name of the object including its path on disk in VBA?
A Full name
27.Which type of list box enables one choice of adjacent choice in VBA?
A Drop down list
B Single – selection list box
C Multiple – selection list box
D Extended – selection list box
28.Which button has three states in VBA?
A Option button
B Spin button
C Push button
D Command button
29.Which box groups related controls into one visual unit in a rectangle with an optional label?
A Label box
B Group box
C List box
D Combo box
30.Where does Excel come in object hierarchy of VBA?
A Range object
B Workbook object
C Worksheet object
D Application object
31.Which shortcut key is used to open project explorer window in VBA?
A Ctrl + R
B Ctrl + P
C Ctrl + W
D Ctrl + E
32.Which shortcut key is used to open VBA Editor from the Excel worksheet?
A Ctrl + F11
B Alt + F11
C Ctrl + V
D Ctrl + F7
33.Which shortcut key is used to step into line – by – line execution in VBA?
34.What is called the set of commands bundled together under one name?
35.What is called the set of statement that are executed under one name?
36.Which one is attributes of an object in VBA?
37.What is called double clicking an object in VBA?
38.Which is used to type / edit the programming code in VBA?
A Form window
B Properties window
C Immediate window
D Visual basic editor
39.Which simplifies the work to be eliminating or rewriting the code in VBA?
40.Which type of variable can be accessed or used by subroutines outside the modules in VBA?