Vba static variable

' 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

Similar codes

0 vote120 views1 answer
Vbnet check if string is only symbols
VBA
0 vote159 views1 answer
Amd64 vs arm64 linux
VBA
0 vote133 views1 answer
Vba count all row
VBA
0 vote117 views1 answer
Limit combobox to list vba
VBA
0 vote119 views1 answer
Get month number from month name vbnet
VBA
0 vote115 views1 answer
Vba exit while
VBA
0 vote126 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote120 views1 answer
Remove frist letter from string vbnet
VBA
25 votes179 views3 answers
String to date vb
VBA
0 vote126 views1 answer
Excel vba Column Name to Column Number
VBA