CODEWITHSUNDEEP
vbaexcel
vinmeg
vinmeg

Reputation: 41

Share Variables stored across PRIVATE modules

Who can advise me, I have 2 private modules where I have a value storred in module 1 e.g. TotalFoundIssues = 166. This value which is stored in module 1, I need to use in module 2, like if TotalFoundIssues is > 100 Do this ..... I see many solutions already but they do not work because they refer to global or public which I need to avoid.

Upvotes: 0

Views: 69

Answers (1)

Kostas K.
Kostas K.

Reputation: 8518

You can expose it through a read-only Public Property:

Private mTotalFoundIssues As Long

Public Property Get TotalFoundIssues() As Long
    TotalFoundIssues = mTotalFoundIssues
End Property

Upvotes: 1

Related Questions