Quick Toggle Question

[Donny]

I want to use a toggle button to change the value of a cell. Seems
easy, I just can't figure out how to change the control of the toggle
button. When the button is up, I want A1 to be "0" and when it is down
I want A1 to be "200." It should be simple to use a toggle button to
toggle the cell value, could someone help me please? Thanks in advance
for your response.

 

[EA]

Try something like....

Private Sub ToggleButton1_Change()
If ToggleButton1.Value = True Then
Range("A1") = 0
Else
Range("A1") = 200
End If
End Sub

 

[PCLIVE]

Use sort of a helper cell. Link the Toggle button to AA1. Then use this
formula in A1.

=IF(AA1=FALSE,0,200)

HTH,
Paul