Recording macros in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to disable screen updating at the start of a macro to improve performance.

Excel

Sub StartMacro()
    Application.[1] = False
End Sub

Drag options to blanks, or click blank then click option'

AScreenUpdating

BRecordMacro

CEnableEvents

DDisplayAlerts

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing with macro recording UI (which can't be started via VBA).

Using True instead of False.

Setting Application.ScreenUpdating = False at the start of a macro prevents screen refreshes, speeding up execution. Re-enable it at the end.

2fill in blank

medium

Complete the code to re-enable screen updating at the end of a macro.

Excel

Sub StopMacro()
    Application.[1] = True
End Sub

Drag options to blanks, or click blank then click option'

AScreenUpdating

BRecordMacro

CEnableEvents

DDisplayAlerts

Attempts:

3 left

💡 Hint

Common Mistakes

Setting to False at the end.

Confusing with actual macro recording (manual UI action).

Setting Application.ScreenUpdating = True at the end restores normal screen updating after disabling it for performance.

3fill in blank

hard

Fix the code to run a recorded macro named 'MyMacro'.

Excel

Sub RunMacro()
    Application.Run "[1]"
End Sub

Drag options to blanks, or click blank then click option'

AMyMacro()

BCall MyMacro

CRun MyMacro

DMyMacro

Attempts:

3 left

💡 Hint

Common Mistakes

Adding () to the string.

Using 'Call' syntax inside Run.

Application.Run "MyMacro" executes the macro by name as a string (no parentheses).

4fill in blank

hard

Fill both blanks for a simple recorded macro that selects cell A1.

Excel

Sub [1]()
    Range("A1").[2]
End Sub

Drag options to blanks, or click blank then click option'

ASelectA1

BSelect

CActivate

DRecordMacro

Attempts:

3 left

💡 Hint

Common Mistakes

Using Activate (for worksheets, not ranges).

Invalid macro names.

Macro name like 'SelectA1'. Recorded actions use Range("A1").Select (not Activate).

5fill in blank

hard

Fill all three blanks for a macro that copies A1 and pastes to B1 (as recorded).

Excel

Sub [1]()
    Range("A1").[2]
    Range("B1").[3]
End Sub

Drag options to blanks, or click blank then click option'

ACopyToB1

BCopy

CPasteSpecial xlPasteValues

DPaste

Attempts:

3 left

💡 Hint

Common Mistakes

Pasting before copying.

Using Select.Copy instead of direct Copy.

Name 'CopyToB1'. Range("A1").Copy then Range("B1").Paste (PasteSpecial for specific formats).