I have an important exam coming up and desperately need the answers to these questions. Please help. I would be highly grateful for the same.
Please select the right option -
Q1. What object is needed to put a userform module in a VBA project?
- associated standard code module
- associated class module
- userForm class
Q2. What is the output of the following?
Q3. The Driver subroutine is declared by Sub Driver (Y). Which statement results in a compile error?
- Driver x
- call Driver(x)
- call Driver x
- Driver (X)
Q4. 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?
Q5. Below is a function named SquareIt. Which version of the subroutine named Area results in a compile error?
1. sub Area()
2. Sub Area()
Q6. 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()?
- 10 rows and 10 columns
- 10 rows and 1 column
- 10 rows and 0 columns
- 1 row and 10 columns