Vba Tricks And Tips - Quiz

10 Questions | By Kumbhalkard | Last updated: Apr 29, 2016 | Total Attempts: 1193

Questions

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

Related Topics

More Programming Language Quizzes

Arduino Quiz 1: The Programming Language

Questions: 11 | Attempts: 9711 | Last updated: Jul 12, 2021

Sample Question
What is the range of numbers you can store in a variable of type byte?

0 to 255

-128 to 127

0 to 9

0 to 65535

0 to 4294967295

Computer Storage & Programming Language Quiz

Questions: 40 | Attempts: 1526 | Last updated: Apr 23, 2021

Sample Question
Information on a computer is stored as what?

Analog data

Digital data

Modem data

Watts data

None of these

Bash Basic Programming Quiz! Test

First released in the late 1980s, BASH is a popular Unix shell that runs in a text window, written for the GNU Project. Are you just starting to learn BASH or want to know how it works before deciding to learn it? If yes, take...

Questions: 10 | Attempts: 1435 | Last updated: Dec 30, 2020