Methodology of teaching some internal functions of Excel & VBA by categories
Keywords:
Public, Private, Friend, Static, Data Types, Integer, MsgBox, Prompt, Buttons, HelpButton, Title, HelpFile, Context, Functions, End FunctionAbstract
To create effective software systems, it is necessary to make full use of the possibilities provided by the Algorithmic Language.
This article examines the built-in functions that are or will be used most often. VBA's built-in functions are among the most commonly used components in programming. Developing optimal software systems depends on effective use of built-in functions.
VB/VBA systems are based on procedures and functions. Procedures and functions are collected in different modules. Depending on the scope, it is possible to load/run these procedures/functions only from the module or from other modules of the project. Only after modules are created do they become objects of Excel&VBA. That is, the components of this project and the modules in the project are connected to various subsystems of the VB editor, including Object Browser, Intelli Sense subsystems, and are used during the assembly and debugging of program codes. The number and types of modules in the project are not limited and are mainly determined on the basis of a pre-prepared "Micro Project".
