getPressed issue

[sunriderdabi]

Hi,

I am trying to set up a checkbox in the ribbon that activates/deactivates iterative calculations.

I manage to get this working. However, I don't manage to update the status of the checkbox if "iterative calculation" status is changed in Excel settings. I can have iterative calculations off while the checbox is on.

Any help is much appreciated, please see simple code below:


Sub IterationCalculations(control As IRibbonControl, pressed As Boolean)
If pressed = True Then
Application.Iteration = True
Else
Application.Iteration = False
End If
End Sub

Sub IsIteraToggled(control As IRibbonControl, ByRef returnedVal)
If Application.Iteration = True Then returnedVal = True
If Application.Iteration = False Then returnedVal = False
End Sub

 

[bobsan42]

I believe you should include the OnAction callback, and maybe name the callback to be clear what they do.
if the first sub is you OnAction Callback it may only contain one line (you don't need if).

[COLOR=#333333]Sub IterationCalculations(control As IRibbonControl, pressed As Boolean)[/COLOR]
[COLOR=#333333]    Application.Iteration = pressed[/COLOR]
[COLOR=#333333]End Sub[/COLOR]

The same goes for the second sub. The second must be called by the getPressed callback: it must be assigned to getPressed in the ribbon XML
if you want to call it during runtime (after the ribbon is loaded) (for testing purposes in this case) try this:

objRibbon.InvalidateControl "[I]YourCheckBoxControlName[/I]"

this will make it get it's value again.
of course you must have assigned the ribbon object to objRibbon at ribbon loading time, to be able to refer to it.