Excel VBA Programming The Complete Guide - Procedure Scope (Public vs. Private)

Excel VBA Programming The Complete Guide - Procedure Scope (Public vs. Private)

Assessment

Interactive Video

Information Technology (IT), Architecture, Business

University

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial explains the concept of procedure scope in VBA, focusing on public and private procedures. It covers how public procedures are accessible within the Excel interface and can be called by other procedures, while private procedures are restricted to the same module and not accessible by the user. The tutorial also demonstrates the use of the 'call' keyword to invoke private procedures from public ones, emphasizing the importance of organizing code for better readability and efficiency.

Read more

1 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF