Vba Tricks And Tips - Quiz

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Kumbhalkard

Kumbhalkard

Community Contributor

Quizzes Created: 1 | Total Attempts: 1,250

Questions: 10 | Attempts: 1,250 | Updated: Mar 21, 2023

Questions

Settings

Create your own Quiz

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
Correct Answer
A. Visual Basic for Applications

Explanation
VBA stands for Visual Basic for Applications, which is a programming language developed by Microsoft. It is used to automate tasks and create custom applications within Microsoft Office programs such as Excel, Word, and PowerPoint. VBA allows users to write code to manipulate data, perform calculations, and interact with the user interface of these applications. It provides a powerful toolset for automating repetitive tasks and enhancing the functionality of Microsoft Office programs.

Rate this question:
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
Correct Answer
C. F8

Explanation
The shortcut keystroke to debug VBA code one line at a time is F8. This key allows the user to step through the code line by line, helping to identify any errors or issues in the code execution.

Rate this question:

1
0
3.

Which of these is not a Visual Basic object?
- A.
  
  Range
- B.
  
  Selection
- C.
  
  FontSize
- D.
  
  Sheets
Correct Answer
C. FontSize

Explanation
FontSize is not a Visual Basic object because it is a property that is used to control the size of the font in an object, such as a textbox or a label. It is not an object itself, but rather a characteristic or attribute of an object. In Visual Basic, objects are typically things like forms, buttons, or textboxes that can be manipulated and interacted with in the program.

Rate this question:
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
Correct Answer
D. Err.Description

Explanation
The Err.Description property in VBA allows you to obtain information about an error. It provides a string that describes the error that occurred, which can be helpful for debugging and troubleshooting purposes. By accessing this property, you can retrieve the specific details of the error that was encountered during the execution of your code.

Rate this question:
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
Correct Answer
C. Xlsm

Explanation
To save a VBA project with an Excel workbook, the workbook must be saved as an xlsm file. The xlsm file format allows for the inclusion of macros and VBA code within the workbook. This file type is specifically designed to support the execution of VBA code and ensures that the macros are saved along with the workbook. Saving the workbook as an xlsx file would remove any VBA code and macros, making it impossible to save the VBA project. Similarly, xlsv and xlv file types do not support VBA code and macros.

Rate this question:
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
Correct Answer
C. On Error Resume Next

Explanation
The correct answer is "On Error Resume Next". This statement allows the VBA code to continue execution even if an error occurs. It effectively skips the line of code that caused the error and moves on to the next line. This can be useful in situations where you want to handle errors gracefully and continue running the code without interruptions.

Rate this question:

0
1
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
Correct Answer
C. Option Explicit

Explanation
The correct answer is Option Explicit. This option in VBA forces all variables to be declared before they are used in the code. By using Option Explicit, it ensures that all variables are explicitly declared, which helps to avoid any potential issues or errors caused by using undeclared variables.

Rate this question:

1
0
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
Correct Answer
D. Show developer tab in the Ribbon

Explanation
To set the developer mode, you need to select the option "Show developer tab in the Ribbon." The developer tab contains various tools and options that are specifically designed for developers to customize and enhance the functionality of Microsoft Office applications. By selecting this option, the developer tab will be displayed in the Ribbon, allowing easy access to features like macros, Visual Basic for Applications (VBA) editor, form controls, and other developer-related tools.

Rate this question:
9.

Which of the following would you begin a comment line with?
- A.
  
  Equal sign
- B.
  
  Double quote
- C.
  
  Underscore
- D.
  
  Single quote
Correct Answer
D. Single quote

Explanation
A comment line in programming is usually used to provide additional information or explanations within the code. In many programming languages, including Python and JavaScript, a comment line is initiated with a single quote ('). Therefore, the correct answer is a single quote.

Rate this question:

1
0
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
Correct Answer
B. Select Case... Case... Case Else... End Select

Explanation
The snippet of VBA code that is not a loop is "Select Case... Case... Case Else... End Select". This is a conditional statement that allows for multiple conditions to be tested and different actions to be taken based on the result. It is not a repetitive structure like the other options which are all different types of loops.

Rate this question:

Vba Tricks And Tips - Quiz

What does VBA mean?

What is the shortcut keystroke to debug VBA code one line at a time?

Which of these is not a Visual Basic object?

Choose the VBA code that will allow you to obtain information about an error.

To save a VBA project with an Excel workbook, the workbook must be saved as what type of file?

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.

To force all variables is a VBA project to be declared, which must be stated in a module?

What do you need to select to set the developer mode?

Which of the following would you begin a comment line with?

Which of the following snippets of VBA code is not a loop?