Static Statement

Declares a variable or an array at the procedure level within a subroutine or a function, so that the values of the variable or the array are retained after exiting the subroutine or function. Dim statement conventions are also valid.

แƒ’แƒแƒ•แƒ แƒ—แƒฎแƒ˜แƒšแƒ”แƒ‘แƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

The Static statement cannot be used to define variable arrays. Arrays must be specified according to a fixed size.


Static VarName[(start To end)] [As VarType], VarName2[(start To end)] [As VarType], ...


Sub ExampleStatic
Dim iCount As Integer, iResult As Integer
    For iCount = 0 To 2
        iResult = InitVar()
    Next iCount
    MsgBox iResult,0,"The answer is"
End Sub
' Function for initialization of the static variable
Function InitVar() As Integer
    Static iInit As Integer
    Const iMinimum As Integer = 40 ' minimum return value of this function
    If iInit = 0 Then ' check if initialized
        iInit = iMinimum
        iInit = iInit + 1
    End If
    InitVar = iInit
End Function

Please support us!