Vba Tricks And Tips - Quiz
10 Questions
| Total Attempts: 1147
Settings
.
Questions and Answers
- 1.What does VBA mean?
- A.
Visual Basic for Applications
- B.
Visual By Arithmetic
- C.
Visual Basic Answers
- D.
Visual By Algorithms
- 2.What is the shortcut keystroke to debug VBA code one line at a time?
- A.
Alt+F5
- B.
F5
- C.
F8
- D.
Ctrl+F8
- 3.Which of these is not a Visual Basic object?
- A.
Range
- B.
Selection
- C.
FontSize
- D.
Sheets
- 4.Choose the VBA code that will allow you to obtain information about an error.
- A.
Err.Title
- B.
Err.Name
- C.
Err.Type
- D.
Err.Description
- 5.To save a VBA project with an Excel workbook, the workbook must be saved as what type of file?
- A.
Xlsx
- B.
Xlsv
- C.
Xlsm
- D.
Xlv
- 6.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.
On Error Resume
- C.
On Error Resume Next
- D.
Next
- 7.To force all variables is a VBA project to be declared, which must be stated in a module?
- A.
Option Declare
- B.
Option Implicit
- C.
Option Explicit
- D.
Option Variables
- 8.What do you need to select to set the developer mode?
- A.
Show macro code settings
- B.
Show mini toolbar on selection
- C.
Show visual basic options menu
- D.
Show developer tab in the Ribbon
- 9.Which of the following would you begin a comment line with?
- A.
Equal sign
- B.
Double quote
- C.
Underscore
- D.
Single quote
- 10.Which of the following snippets of VBA code is not a loop?
- A.
Do While... Loop
- B.
Select Case... Case... Case Else... End Select
- C.
Do Until... Loop
- D.
For Each.. Next
Back to top