michaelch2934
New Member
- Joined
- Sep 17, 2018
- Messages
- 34
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.
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.