vba static variable
' Import as a file MyStaticClass.cls:
VERSION 1.0 CLASS
BEGIN
MultiUse = -1 'True
END
Attribute VB_Name = "MyStaticClass"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private mStaticCol As New Collection
Public Sub Push(ByVal pIndex As String, ByVal pValue As String)
Attribute Push.VB_Description = "Pushes a new value into StaticCol."
mStaticCol.Add pValue, pIndex
End Sub
Public Property Get Element(ByVal pIndex As String) As String
Attribute Element.VB_Description = "Returns the element."
Element = mStaticCol.Item(pIndex)
End Property
'--------------------------------------------------------------
' In a module:
Sub TesMe()
With MyStaticClass 'No instanciation, mStaticCol is shared
.Push "Jay", "circle"
Debug.Print .Element("Jay")
End With
End Sub
4.5
2
' Static variable inside a function
Function MyStaticFunction(ByVal pToAdd As Integer) As Integer
Static iStatic As Integer ' Keeps its value between calls
iStatic = iStatic + pToAdd
MyStaticFunction = iStatic
End Function
'---------------------------------------------------------------------
Sub TesMe()
Debug.Print MyStaticFunction(1) ' 1
Debug.Print MyStaticFunction(3) ' 4
End Sub
Thank you!
2
0
Are there any code examples left?
New code examples in category VBA
-
VBA 2022-03-27 20:55:02 excel vba check if all substrings in list are in string
-
VBA 2022-03-27 20:40:39 excel vba set cell value to empty
-
VBA 2022-03-27 17:05:52 vba simple quote
-
VBA 2022-03-27 14:30:19 textbox find and replace vb
-
VBA 2022-03-27 09:10:21 nested if else in vb.net
-
VBA 2022-03-27 09:10:09 excel vba string to bits
-
VBA 2022-03-25 02:00:15 vba verticalalignment
-
VBA 2022-03-24 12:20:06 Excel web scraping
-
VBA 2022-03-24 10:11:00 excel vba BitToLong
-
VBA 2022-03-21 18:00:05 excel vba save file txt