Hi, Quick question here, I hope
how do I keep a boolean variable = true and keep that value for every sub or
function that might use it? im having problems when going from one
sub/function to another. The variable keeps getting reset to = "Empty". Do i
actually have to pass it from function to function? What if its used in a
sub? or am i missing something? Thanks

Hi


Declare it as Public


Public MyVar As Boolean
Sub mysub()
MyVar = True
End Sub

Mike

"James" wrote:

Hi, Quick question here, I hope
how do I keep a boolean variable = true and keep that value for every sub or
function that might use it? im having problems when going from one
sub/function to another. The variable keeps getting reset to = "Empty". Do i
actually have to pass it from function to function? What if its used in a
sub? or am i missing something? Thanks