Toggle Button (Excel 2004 VBA)

Topic

New Reply

I want to create a toolbar with a toggle button (on of off) but I cannot get it to stay ‘in’. Help.

Reply | Quote

Replies

Have you tried using
mnuWhateverYouCalledIt.State = msoButtonUp
and
mnuWhateverYouCalledIt.State = msoButtonDown

StuartR

Reply | Quote

Stuart,

The code that I am using is

With CommandBars("CommandBar").Controls("Button")
    .FaceId = 1762
    .Caption = "New Caption"
    .OnAction = "New Action"
End With

There doesn’t seem to be a .state for controls.

Reply | Quote

.State is a property of a CommandBarButton. If the control is a button, you should be able to set its properties like so, more or less:

dim cBtn as Commandbarbutton
Set cBtn = CommandBars(“CommandBar”).Controls(“Button”)
With cBtn…

Reply | Quote

Thx Jeff – once I had got my caption correct, it worked like a dream.
Thx Hanv for pointing out the intellisense short comings – shows what happens when we let the machine think for us.

Reply | Quote

As Jefferson indicated, State is a property of a CommandBarButton. In your code, IntelliSense cannot know that Controls(“Button”) is a CommandBarButton, so it doesn’t list State as a property. You should still be able to type it yourself. Or use the code suggested by Jefferson.

Reply | Quote