Easy Object variables question

[craigyg]

When I declare an object variable in a subroutine using the dim statement, can I use that object variable throughout the module or only in that subroutine. What about if I use the public statement?

 

[Norie]

Where/when you can use variables is all down to scope.

That's basically determined by where/how you declare them.

Try a search for scope in the Excel VBA help for more detailed information.

If you want more specific advice post back with more information on what you actually want to do.

 

[erik.van.geit]

Hi,

some more info
http://www.cpearson.com/excel/variables.htm
http://www.cpearson.com/excel/DeclaringVariables.htm

declaring on top of the module
variable a will be recognized in the enire module
run aa

Dim a as string

Sub aa()
a = "string"
bb
End Sub

Sub bb
MsgBox a
End Sub

public ==> variable lives as long as workbook is open

Public a As String

Sub aa()
a = "ert"
End Sub

Sub bb() 'can be in other module
MsgBox a
End Sub

some experts will tell you to avoid public variables
you can use instead "calling procedures with arguments"
like this

Sub runthis()
Call macro(1, 3)
Call macro(2, 5)
Call macro(99, 101)
End Sub

Sub macro(var1 As Integer, var2 As Integer)
MsgBox var1 & " + " & var2 & " = " & var1 + var2
End Sub

'or just use
'macro 1, 3

kind regards,
Erik