VBA MCQ Questions Answers

1. A VBA project must declare four classes. How many class modules are needed?

2. If VBA code declares FileCount as a constant rather than a variable, the code tends to run faster. Why is this?

3. To use VBA code to maintain a different VBA project, you can make use of VBA's extensibility. What is needed to enable extensibility?

4. Which statement declares an array?

5. When used with an array named MyArray, what is the preerred way to set beginning and ending values of a loop control variable?

6. What is needed for the contents of Module1 to be availble to other modules in a VBA project, but not to any other VBA project?

7. How does a class module indicate that it uses a particular interface?

8. When you define a new class of object, where do you assign a name to it?

9. Which keyboard shortcut causes VBE to locate the declaration of a procedure?

10. Which action will cause your project to reset its variables?

11. There are two references that must be selected in the Visual Basic Editor in order for any Visual Basic code to run in Excel. What are these two references?

12. A declaration has scope, which has three levels. What are they?

13. Which statement is true?

14. Which statement should precede a subroutuine's error handler?

15. The recording of a macro in Word is likely to be an incomplete record of the user's actions. Why?

16. Which variable name is valid in VBA?

17. Which cell is selected if you run this code Range("E3:312").Range("B3").Select

18. EmailAddress() is an array. It is declared by Dim EmailAddress(10) As String, and option Base 1 is in effect. How many rows and columns are in EmailAddress()?

19. You have several variables to display on a user form, and there are too many variables to display at once. Which control best enables the user to see all the variables?

20. What is the principal difference between a class and an object?

21. This code shows the first statement of CalledSub. Which calling statement will work properly? Sub CalledSub(Surname, Age)

22. What is PlainText ?

23. In the statement 'x = 400 * y', what is the maximum value that y can be if x has been declared as in Integer?

24. What is a Collection object?

25. How can we declare a subroutine or function in VBA?

26. To return the value of the Access database file's path, what VBA code will retrieve the value?

27. In order to prevent users from deleting database objects displayed in the Navigation Pane, what VBA code would be used?

28. To concatenate two lines of VBA code into one line, insert which character between the two joined lines?

29. To create one array variable to store monthly mortgage rates over the course of a year, the following is the best declaration statement.

30. Choose the function used to send an table's contents in Excel format by email from Access.

31. Choose the VBA code to allow you to obtain the value from Row 2 and Column 3 of a mutliple column listbox.

32. A VBA unit is called a _____.

33. To change the font color a textbox field, choose the VBA code that will allow you change the control's property.

34. What reference will you add to add active x objects ,i.e. buttons, at runtime?

35. Which tools should be used to compile the program?

36. What is the short cut to get Immediate Window

37. Which of the following would NOT be a good use for a macro?

38. Output of below code: Dim a As Integer Dim b As Integer a = 1000 b = 33 MsgBox a * b

39. To remove the records listed in a subform, which property and value would you need to add to your VBA code.

40. Out put of below code: Dim a As Single Dim b As Single a = 7 b = 2 MsgBox a / b & ", " & a \ b

41. What is a result of this code? Sub Test() Dim myNumber As Double myNumber = -10.635 Debug.Print Fix(myNumber) Debug.Print Int(myNumber) End Sub

42. Choose the VBA code used to close database and the Microsoft Access instance.

43. Choose the VBA code that will allow you to check to see if the form MainMenufrm is loaded.

44. Choose the VBA code to filter the rowsource in a multiple column listbox that will allow you to filter the records listed using the LIKE statement and the variable xCompany.

45. Without using SQL, choose the VBA code to allow you to delete the table Employees.

46. Which statement will assign a random integer from 1 to 5 to the variable x?

47. The ____________ allow(s) for multiple controls in a user form, to execute the same sub.

48. Choose the VBA code that you would use to call a public function named VBAFunction from a form called FormA while passing a variant x1 in the module of FormB form. 

49. When you have added a new linked table using VBA code and it does not appear in Navigation Pane that displays the list of tables, forms, macros, and queries in the database.  Which VBA code would you use to update the list of database objects displayed in the Navigation Pane.

50. What will Format(“A123”, “&&&&&&”) output?

51. Which is NOT a method of the Workspace object:

52. You want to count how many records for a given customer based on CustomerID which is of field type short text in table tblCustomer. The customer id we want the count for is 123-AC. We are using the domain aggregate function DCount and assign it to an integer variable intC what is the correct syntax.

53. Which function will allow you to convert a value to number?

54. Where you can create you custom events?

55. You want to dump the values stored in a 12-element array named Rates into the cell range A1:A12.  How can you get that done?

56. The application property that will assign a shortcut key to run a macro is:

57. Choose the VBA code that you would use to obtain the user login on a computer using a Windows operating system.

58. Which Will Not display VBA code?

59. When integrating Excel, instead of adding a reference, which VBA code would you use to open Microsoft Excel.

60. Is it possible to expand storage space for dynamic Array variables with two or more dimensions, keeping the existing data?

61. Choose the VBA code used to add a new record to the recordset xRec.

62. What stores Excel data?

63. In Access, which VBA code will allow you to suppress alerts when deleting records from a table.

64. True or False? An 'If-Then' statement must always be paired with an 'End If'.

65. Which of the following snippets of VBA code will allow you to return the first array index in the array xItems?

66. Choose the VBA code to remove data from Row 2 in a multiple column listbox.

67. With out creating a reference to the Microsoft Scripting Runtime for the DLL to create a Dictionary object, choose the VBA code to allow you to do so.

68. When integrating Excel, which VBA code will allow you transfer data from recordset xRec in Access directly onto a spreadsheet (xlws) in Excel.

69. Choose the VBA code to execute a Word MailMerge in Access

70. As an alternative to the If.. Then.. ElseIf..Else condition, how would you format the Choose function with variable x1 and the following conditions:  "Red", "Blue", "Yellow", "White"

71. What is BOF?

72. What is the difference between these commands CreateObject("Word.Application") GetObject(, "Word.Application")

73. What is the right syntax to raise your custom error?

74. Which is the correct way to use formulas on Excel in VBA code

75. In the next statement: "Dim bValue as Boolean" What will be the default value for "bValue" variable?

76. Under which menu option in the VBA IDE can you password protect a VBA project?

77. The library to make ADODB.connection work.

78. You have written a function called Switch requiring the input string parameters a and b. The function will concatenate the values assigned to b and a, in that order. What line of code is needed within the function?

79. Month(#12/25/02#) will output?

80. 'Do While x < 5' is equivalent to:

81. What will Format(2.36, “#0.0”) output?

82. What value is x holding after this statement is executed: x = Left("Apple",3) & Right("People", 3)

83. Choose the VBA code that will allow you to verify that an Item exists in the Dictionary object Dict1. 

84. When stepping through code as a way to see how the values in variables change, use the:

85. Which code will allow user to edit a password protected worksheet.

86. To change the text displayed in a label on a form, choose the VBA code that will allow you to update the property.

87. Combine into one line: If x > 5 Then y = x - 5 End If

88. To change a comment in cell A1, which will do the job?

89. What is the difference between activating and initializing a user form?

90. Which of the following actions will NOT cause a macro to run in Excel?

91. Choose the VBA code that switches control from the application to the OS.

92. What does the DoEvents do?

93. Which of the following functions do not perform a calculation

94. What is the property of a cell that allows you to set the font color of the contents?

95. 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?

96. The statement 'Dim a, b as Single' declares the variables a and b as what variable types?

97. Dim a,b as integer What is the type of a?

98. Which of these statements will start a loop of exactly 20 iterations?

99. Which of the following VBA windows shows the code of the active object?

100. The way to pass the latest values of variables between functions and procedures is identified as: