Initializing a global variable

[samsung180]

I would like to set a variable (let's call it var) as having an initial value of 0.
I would like this to be set outside of a function so that when I run a function, var does not have its value always reset to 0.
For example, here is something similar to what I'd like:

Dim var As Integer
var = 0

Public Function justAnExample ()
var = var + 1
End Function

Any help? Thanks.

 

[MrKowz]

Welcome to the forums!

Try declaring the variable in this manner:

[B]Public Const var As Integer = 0[/B]

Sub Foo()
MsgBox var + 1
End Sub

 

[mikerickson]

Have you considered something like

Function JustAnExample2(Optional Reset as Boolean = True)
    Static myValue as Long

    If Reset Then
        myValue = 0
    Else
        myValue = myValue +1
    End If

    JustAnExample2 = myValue
End Function

 

[samsung180]

Basically, I just want a variable to start at 0, then for each iteration of my function, have its value increased by 1 (thus why a constant will not work here).

Maybe this will work:

Sub varDeclaration ()
var = 0
End Sub

 

[mikerickson]

=JustAnExample2(FALSE) will act that way.

Try putting this formula in a cell. It will re-calcualte any time that A1 is changed

=JustAnExample2(A1<>A1)