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

by

Dim and Private work the same, though the common convention is to use Private at the module level, and Dim at the Sub/Function level. Public and Global are nearly identical in their function, however Global can only be used in standard modules, whereas Public can be used in all contexts (modules, classes, controls, forms etc.) Global comes from older versions of VB and was likely kept for backwards compatibility, but has been wholly superseded by Public.

More Related Contents:

  1. Does VBA have Dictionary Structure?
  2. Is there a need to set Objects to Nothing
  3. VB6 pass by value and pass by reference
  4. What does the Call keyword do in VB6?
  5. Difference between Visual Basic 6.0 and VBA
  6. VBA : save a file with UTF-8 without BOM
  7. IsDate function returns unexpected results
  8. Alternative IDE for VB6 and VBA [closed]
  9. User Defined Type (UDT) as parameter in public Sub in class module (VB6)
  10. to make this code simpler
  11. Get reference to additional Inbox
  12. How to create and write to a txt file using VBA
  13. Save text file UTF-8 encoded with VBA
  14. Outlook VBA – Run a code every half an hour
  15. Excel VBA deleting rows in a for loop misses rows
  16. Execute a command in command prompt using excel VBA
  17. Searching an excel with two search words (multiple lookup) using vba macro [closed]
  18. VBA Shell and Wait with Exit Code
  19. Insert line break in wrapped cell via code
  20. MS Access: how to compact current database in VBA
  21. How do you extract email addresses from the ‘To’ field in outlook?
  22. Can I Get the Source Range Of Excel Clipboard Data?
  23. Using visual basic to access subfolder in Inbox?
  24. How to create dynamic variable names VBA
  25. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  26. How to get the procedure or function name at runtime?
  27. Copy an array reference in VBA
  28. How to get selected value in multicolumn listbox
  29. What does the To and Step mean in VBA?
  30. Query my excel worksheet with VBA

Leave a Comment