How to set ToggleButton state from VBA code?

**bsabiston** · 02-21-2019, 01:20 PM

Hello,

I have a Ribbon with some toggle buttons on it. There's a custom UI xml where the buttons are defined, with 'getPressed' and 'onAction' callbacks defined. Also, this particular button is enclosed with another one in a 'group' in the xml.

When the user presses one of these, occasionally I want to cancel the press, so I want to set the pressed state back to false. How can I do this?
My onAction Sub looks like this - it takes an IRibbonControl as an argument:

Please Login or Register  to view this content.

Online I found reference to just setting the 'Value' of the control to false, but that gives me an error. I thought the problem might be that the argument needs to be a ToggleButton instead of an IRibbonControl. I tried adding a 'ToggleButton' variable and then setting that variable to argument 'oControl', but I got a 'user-defined type not defined' error, like it didn't know what a ToggleButton was. But 'ToggleButton' is a system type, isn't it? Why isn't it recognized?

Anyone know how I can set this toggle button value from a Sub?

Thanks!

**bsabiston** · 02-21-2019, 02:35 PM

Ok I figured this out - the 'pressed' state is actually modifiable just by changing the ByRef argument, in this case 'bPressed'. I set that to False. Also, I had to call Invalidate on the control via the ribbon ID, like this:

goRibbon.InvalidateControl ("ButtonMoveRows")