Excel VBA Excel VBA Automation & Macros

Question 1

Which VBA event fires automatically when a workbook is first opened?

Accepted Answer

Workbook_Open

Answer

The Workbook_Open event procedure runs automatically each time the workbook is opened.

Question 2

How do you prevent screen flickering while a VBA macro runs?

Accepted Answer

Application.ScreenUpdating = False

Answer

Setting Application.ScreenUpdating to False suspends screen redraws, eliminating flicker and speeding up macros.

Question 3

Which VBA property disables automatic recalculation during a macro for performance?

Accepted Answer

Application.Calculation = xlManual

Answer

Setting Application.Calculation to xlManual prevents Excel from recalculating formulas after every cell change.

Question 4

What does the Application.EnableEvents property control?

Accepted Answer

Whether worksheet and workbook event procedures fire automatically

Answer

Setting EnableEvents to False prevents VBA event procedures from triggering during programmatic changes.

Question 5

How do you run another macro from within a VBA procedure?

Accepted Answer

Call MacroName or just MacroName

Answer

You can invoke another subroutine using the Call keyword followed by the name, or simply write the name with arguments.

Excel VBA Practice Test