Quick Toggle Question
 

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.

Quick Toggle Question
 

Try something like....

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


"Donny" wrote in message
ups.com...
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.

Quick Toggle Question
 

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

"Donny" wrote in message
ups.com...
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.