ToggleButton on the Ribbon

[Stevenn]

I've made a togglebutton on the ribbon in Excel 2007, but I don't know how to check whether the button is pressed or not in a module.

Does anyone know how to handle this problem?

 

[RoryA]

the callback for the togglebutton provides the state. if you need to check that from an unrelated procedure, then the onAction callback needs to store the value in a variable (or cell) that you can check later.

 

[Stevenn]

Right now my onAction procedure looks like

Public Sub Toggle_is_clicked(Control As IRibbonControl, pressed As Boolean)
    If pressed Then
        Range("use_forms").Value = 1
    Else
        Range("use_forms").Value = 0
    End If
End Sub

but I don't want to store it in a cell. What is the alternative?

 

[RoryA]

you can store it in a variable instead (declared outside the callback so that it retains its value) or in the registry or a text file.

 

[Stevenn]

you can store it in a variable instead (declared outside the callback so that it retains its value) or in the registry or a text file.

Isn't it possible to store values in the ribbon? I would have thought it was possible to store values just like it's possible to store font type, font size in the Home tab.

 

[RoryA]

if that worked, and you could then retrieve the values, you wouldn't need to do it since you could just read the state of the togglebutton directly.