Embedded Forms

[mnordeen]

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.

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 .

 

[Peter_SSs]

the problem is in order for the code to run you must double click the button, ...

I don't understand just what you are getting at here. Can you clarify further?

 

[mnordeen]

Hey Peter, I will try..

Under the "Control Tool box" you can insert a "Toggle Button"

in that toggle button you can set the properties to a Linked cell (amoung other things), you can also Veiw code of that button(for wich I entered the code above).

The button itself is on the worksheet, if you click on the button (single-click)the the button reacts and shows it is pressed also the cell linked reacts But the Macro in the button does not you must (double-click) it for the macro to run.

I have looked all threw the properties of an "toggle Button" and cant see why, any idea?

 

[Peter_SSs]

OK, I think I understand what you are saying - but I cannot replicate it. When I click the button..
- the button shows depressed
- the linked cell updates
- cells P18, P19, Q18 get completed.

A few questions..
1) What is your linked cell?
2) Is this the full code for the button_click event?
3) If so, since I cannot see anything being "toggled", why are you using a ToggleButton rather than a CommandButton?
4) If not, maybe posting your whole code might help.

I guess all that means you might need to fill out more detail about what you have on the sheet and what you are trying to achieve?

 

[Legacy 98055]

In design mode, right-click your togglebutton, select properties, see the TripleState property I'm betting that you accidentally set its value to true. Make it false.

Peter. To see his problem, set the property to true...

 

[mnordeen]

Sorry it took a bit to post a follow up,
Right click that did it but I really dont remember changeing it anway.
Oh well thanks!