Excel VBA Excel VBA 3

Question 1

Which VBA event fires when a cell's value is changed by the user on a worksheet?

Accepted Answer

Worksheet_Change

Answer

The Worksheet_Change event fires whenever a user or external link changes a cell in the worksheet.

Question 2

What does Application.ScreenUpdating = False do in a VBA macro?

Accepted Answer

Prevents the screen from refreshing while the macro runs

Answer

Setting ScreenUpdating to False stops the screen from flickering during macro execution, improving speed.

Question 3

Which function returns the number of characters in a string in VBA?

Accepted Answer

Len

Answer

Len(string) returns the number of characters contained in the string argument.

Question 4

In VBA, what does the keyword 'Me' refer to inside a UserForm's code module?

Accepted Answer

The UserForm itself

Answer

Me refers to the instance of the class (UserForm, worksheet, or workbook) in whose code module it appears.

Question 5

What VBA construct handles errors that occur during runtime?

Accepted Answer

On Error GoTo

Answer

VBA uses On Error GoTo [label] to redirect execution to an error-handling block when a runtime error occurs.

Excel VBA Practice Test