Vba Tricks And Tips - Quiz

10 Questions

Settings
Please wait...
Programming Language Quizzes & Trivia

.


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. 
    • 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