08 - Worksheet Events Quiz - Excel VBA Is Fun

Worksheet events are contained within a separate module in the Visual Basic Editor and never within the worksheet itself as a container for the VBA code. . .

True

False

Worksheet events (which are contained in the worksheet you're working on) can refer to that worksheet as Me.

So instead of:

Thisworkbook.sheets("sheet1").range("a1") = "hello"

in this instance, you could just put:

Me.range("a1") = "hello"

True

False

The BeforeDoubleClick Event includes double right-clicking.

True

False

A Worksheet_Change Event occurs or is triggered:

When you click on a different cell

When you modify the value of a cell and hit enter, tab or deselect the cell in any other way

When you select a different worksheet or workbook

By explosives. It is triggered by explosives.

08 - Worksheet Events Quiz

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question