Hello all,
I am going to try to explain this one, I have an embedded "Toggle Button" in a sheet. When the button is pressed I have this in the code for the button.
the problem is in order for the code to run you must double click the button, but the button will depress with only a single click. I dont see anything in the properties for the button that might explain this any Idea whats wrong????
I hope I explained that well enough .
I am going to try to explain this one, I have an embedded "Toggle Button" in a sheet. When the button is pressed I have this in the code for the button.
Code:
Private Sub ToggleButton1_Click()
With ActiveSheet
.Range("p19").Value = Now()
.Range("p18").Value = True
.Range("q18").Value = False
End With
End Sub
the problem is in order for the code to run you must double click the button, but the button will depress with only a single click. I dont see anything in the properties for the button that might explain this any Idea whats wrong????
I hope I explained that well enough .