Application 1 Quiz

How do you link an existing Button to a sub(when the button is clicked, the code in the sub runs)?

Double-Click on the button and select "Insert Macro"
Right-Click on the button and select "Format Control"
Right-Click on the button and select "Assign Macro"

What does Debug.Print do?

Writes output to the Immediate Window
Writes output to the Printer
Writes output to the Watch Window
Writes output to the Locals Window

What happens when we run the code below:

 Public Sub CreateReport()
 
 ' 1. Turn off functionality such as auto calculations
  
 ' 2. Clear existing data
  
 ' 3. Find and copy matches
  
 ' 4. Turn functionality back on 

 End Sub

We get an error because VBA doesn't understand text like this.
Nothing happens. VBA ignores any lines of code that start with apostrophe(')
VBA will print the text to the Immediate Window

How do you run a Sub from the Visual Basic Editor?

Without clicking anywhere in particular press F5 and select the Sub from the list.
Click in the sub and Select Run->Run Sub/UserForm from the menu.
Click in the actual Sub and press F5.
All of the above are correct

Which of the following statements is true?

The Const value can be changed by the code once it is set
```
Const total As Long = 8
total = 10
```

The value of a Const can be assigned to a variable e.g.

Const total As Long = 8
Dim newTotal As Long
newTotal = total

A variable value can be set within the Dim statement e.g.
```
Dim total As Long = 8
```
If we set the const value when we declare it we will get an error e.g.
```
Const total As Long = 100
```

What’s the difference between a Public and Private Sub?

A Public Sub can be called from any module. A Private Sub can only be called from the module where it exists.
A Private Sub can be called from any module. A Public Sub can only be called from the module where it exists.
There is no difference unless you are using Class Modules
All of the Above

Which of these is true about the code name of the Worksheet?

The code name allows us to directly reference a worksheet in the current workbook e.g.
```
sheetCodename.Range("A1").Value = 45
```
The code name allows us to reference a worksheet using the Worksheets property e.g.
```
ThisWorkbook.Worksheets("SheetCodename").Range("A1").Value = 45
```
The code name can be changed by the user from the Excel worksheet
If the user changes the name of the worksheet then the code name will no longer work correctly

When is it correct to indent our code?

Between lines such as If and End IF, Select and End Select, For and Next.
The first 3 lines in our Sub our Function
When declaring and using Variables
Any time we read from a Range.

Which of these lines is used to open a file?

Set wkBook = ThisWorkbook.Open(Filename:="C:\Temp\data.xlsm", ReadOnly:=True)

Set wkBook = VBA.Open(Filename:="C:\Temp\data.xlsm", ReadOnly:=True)

Set wkBook = Workbooks.Open(Filename:="C:\Temp\data.xlsm", ReadOnly:=True)

Set wkBook = ThisWorkbook.OpenFile(Filename:="C:\Temp\data.xlsm", ReadOnly:=True)

Given the following worksheet, what range will the code below return?

Dim rg As Range
Set rg = shData.Range("A2").CurrentRegion

A1:B6
A1:E6
A1:B3
None of the above

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

You are not logged in