In VB6/VBA, you can declare module-level variables outside of a specific Sub or Function method. I've used Private and Public before inside modules and understand them like so: Public - visible to all code inside the module and all code outside the module, essentially making it global. Private - visible only to code inside the module. I've noticed that you can use Dim and Global as modifiers for modular variables. Are Dim and Global different from Private and Public , respectively, when used as access modifiers on modular fields? If so, how are they different?

What is the difference between Dim, Global, Public, and Private as Modular Field Access Modifiers?

In VB6/VBA, you can declare module-level variables outside of a specific Sub or Function method. I've used Private and Public before inside modules and understand them like so:

Public - visible to all code inside the module and all code outside the module, essentially making it global.
Private - visible only to code inside the module.

I've noticed that you can use Dim and Global as modifiers for modular variables. Are Dim and Global different from Private and Public, respectively, when used as access modifiers on modular fields? If so, how are they different?

What is the difference between Dim, Global, Public, and Private as Modular Field Access Modifiers?

1 Answers