MS VBA Excellence - Coming to Terms - Lesson 2
Ready to elevate your Excel game? Dive deep into essential Excel VBA terms with our expert-led video tutorial. Uncover the meaning behind keywords like subroutines, modules, and declarations while discovering how they can revolutionize your spreadsheet workflow. With clear explanations and real-world examples, this is a must-watch for anyone looking to harness the full potential of VBA within Excel. Get ahead of the curve - hit play now!
Get the database and or more info at https://grocerydynamite.com
Watch the video: • The Revolutionary Grocery Shopping Da...
Private vs Public Subs & Modules
When it comes to creating VBA macros, the designation of Private or Public is important. It defines how the VBA code within one module could interact with the VBA code in a separate module. This is applicable to both the Private Subs or Private Functions.
A Public Sub or Function has more visibility across the Workbook, Outlook, Access, Word or Powerpoint presentation. For instance, with social media account profiles, there are parts that we allow the public (non-followers) to see and private areas for only (followers) to see. In dealing with VBA, the distinction is not as straightforward nor apparent.