Static sub not preserving variables between calls

[Glory]

I don't understand why this is happening. This sub calls a function if a certain Boolean variable is "Not" true. The problem is that this variable is always Empty when the procedure is called. This makes no sense to me.

Public Static Sub caller()
 
If Not theVariable Then Populate
 
theVariable = True
 
End Sub

The idea here is that the function runs once, and then doesn't run again unless the workbook is closed and reopened.

 

[hiker95]

Glory,

I hope this helps.

If you declare theVariable as Public, then the variable will hold the True False value while the workbook is open, and is available to all your other macros.

Public theVariable As Boolean

Public Static Sub caller()

If Not theVariable = True Then
  theVariable = True
End If
 
End Sub

 

[Glory]

I actually already did and forgot to mention that.

It's really weird that this is not working. The variable is uninitialized every time the code runs, though. It's always empty until I explicitly let it be True.

 

[Glory]

Uh... I take it back, I guess? For some reason tonight it's working. I mean, I literally changed nothing, I just opened the workbook I had been toying with last night and ran the code and it started working.

Thanks anyway.