How to prevent showing backing private fields of class properties in the Locals window?

by

As comments & answers already said, that’s just the VBE being helpful.

However if you find it noisy to have the private fields and public members listed in the locals toolwindow, there’s a way to nicely clean it up – here I put the Test procedure inside ThisWorkbook, and left the class named Class1:

clean locals toolwindow

So what’s going on here? What’s this?

Here’s Class1:

Option Explicit

Private Type TClass1
    Name As String
    '...other members...
End Type

Private this As TClass1

Public Property Get Name() As String
    Name = this.Name
End Property

Public Property Let Name(ByVal value As String)
    this.Name = value
End Property

The class only has 1 private field, a user-defined type value named this, which holds all the encapsulated data members.

As a result, the properties’ underlying fields are effectively hidden, or rather, they’re all regrouped under this, so you won’t see the underlying field values unless you want to see them:

locals toolwindow, 'this' field expanded

And as an additional benefit, you don’t need any pseudo-Hungarian prefixes anymore, the properties’ implementations are crystal-clear, and best of all the properties have the exact same identifier name as their backing field.

More Related Contents:

  1. Pass arguments to Constructor in VBA
  2. Rearranging Excel Cell based on Value [closed]
  3. How do I get the old value of a changed cell in Excel VBA?
  4. For Each loop: Some items get skipped when looping through Outlook mailbox to delete items
  5. Force a screen update in Excel VBA
  6. How to make Excel VBA variables available to multiple macros?
  7. Use of symbol # (hash) in VBA Macro
  8. Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
  9. Excel VBA looping through multiple worksheets
  10. When one should use Set [e.g for SpecialCells return value]?
  11. Excel: macro to export worksheet as CSV file without leaving my current Excel sheet
  12. Distinction between using .text and .value in VBA Access
  13. VBA ServerXMLHTTP https request with self signed certificate
  14. How to add data validation to a cell using VBA
  15. Getting AD Details based on username
  16. How to break long string to multiple lines
  17. How to loop through all controls in a form, including controls in a subform – Access 2007
  18. How to copy a chart from Excel to PowerPoint?
  19. vba paste not working
  20. FileDialog doesn’t work
  21. How to refer to Excel objects in Access VBA?
  22. mac excel vba loop : from list & then export as pdf
  23. How to add an embedded image to an HTML message in Outlook 2010
  24. Speed up multiple replacement
  25. Reading Web Pages using Excel VBA
  26. Excel VBA: auto click and open file from website
  27. MS Access VBA: Sending an email through Outlook [closed]
  28. Open Google Chrome from VBA/Excel
  29. Excel VBA Run-time error 1004 when inserting or value formula into cell
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment