The Ultimate Excel VBA Course - Learn and Master VBA Fast - Subroutines

The video tutorial guides viewers through using the VBA editor to create and manage subroutines. It covers creating two subroutines, formatting cells, saving and accessing subs, and differentiating between public and private subs. The tutorial also demonstrates how to activate one subroutine from another and test the code to observe changes in an Excel worksheet.

What is the purpose of declaring a variable in the 'first code' subroutine?

• To create a new worksheet

• To change the font size

• To save the workbook

• To store the value of the active cell

Which font is used in the 'second code' subroutine?

• Times New Roman

• Arial

• Calibri

• Verdana

How can you execute one subroutine from another in VBA?

• By changing the font

• By saving the workbook

• By clicking a button

• By typing its name

What happens when you make a subroutine private?

• It becomes visible in the Assign Macro dialog box

• It automatically runs when the workbook opens

• It cannot be executed

• It does not show up in the Assign Macro dialog box

What change is observed in the worksheet after executing the code?

• The worksheet is deleted

• The text in cell A1 changes

• A new worksheet is created

• The workbook is closed