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

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

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

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.

Read more

2 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the effect of making a sub private in VBA?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What should you do to save your code in the VBA editor?

Evaluate responses using AI:

OFF