Constants & Enumerations || Excel VBA Master Class || 3.2
Use Constants in place of raw, fixed values within the VBA code. Creating and using a Constant roughly follows the same pattern as a Variable, with a few key differences. We will learn more within this video.
There are system defined constants and user defined constants. We will start with browsing system defined or intrinsic constants within the Object Browser. Then, we will check out how to create our own user defined or symbolic constants.
We can group similar constants into Enumerations which can be accessed as a single set within it's individual member. We will explore this topic as well.
#vba #excel
Follow the rest of the series, in the below playlist:
• VBA MasterClass
Code snippets can be found here:
https://skillsandautomation.com/maste...
00:00 Intro
00:35 System-Defined Constants
03:00 User-Defined Constants
07:28 Enums (System-Defined)
09:49 Enums (User-Defined)
