"True" is true throughout worksheet

[michaelch2934]

In one application, I want to determine if a value is true or false. But, once it is set to "True", I want to use this fact throughout the worksheet. Conversely, if this value is "False", I want to likewise use this fact throughout the worksheet.

This is the code I'm using to determine what BackColor is:

Sub BlueTurnButton_Click()
'change blue button color to "on"
BlueTurnButton.BackColor = 16765783
'change red button color to "off"
RedTurnButton.BackColor = 186
'set varable
If BlueTurnButton.BackColor = 16765783 Then
BlueTurn = True
End If
If RedTurnButton.BackColor = 186 Then
RedTurn = False
End If

Now, I want to refer to this True or False nature of BlueTurnButton.BackColor in other applications. If it's True, do thus and so. Inotherwords, if it's Blue's Turn, then this happens. But, if it's Red's Turn, this other thing happens.

Hope I've explained it sufficiently well enough for you to help me with a viable solution. Thanks in advance.

 

[shg]

Declare it in a standard code model, above all procedures, just below Option Explicit:

Dim BlueTurn As Boolean

... and nowhere else.

See VBA Help for Understanding Scope and Visibility

 

[michaelch2934]

Interesting. I'll try it. Thanks.

 

[michaelch2934]

Fellow Texan, this seems to work like a charm. Thanks again, pardner.

 

[shg]

I misinformed.

That makes BlueTurn visible throughout the code module in which it appears. To make it visible throughout the project,

Public BlueTurn As Boolean

 

[michaelch2934]

Okay. I'll try that, as well. Maybe use both. Thanks.
If I wanted to send you the end product (game) how would I do so?

 

[shg]

Not a gamer, thanks.

 

[michaelch2934]

Me neither, in the modern sense. My games are in the classic style... Sorry, Connect 4, Checkers, Scrabble... Only re-imagined.