Hi, After hours of readings and tries, I don't get how to change the value of a toggle button to false (not pressed) with VBA. Sub TbtnManClick(control As IRibbonControl, Pressed As Boolean) Dim Manvalue As Variant Manvalue = InputBox(Range("LgMan"), Range("LgMan"), Range("RngMan")) Range("RngMan") = Manvalue If I message MsgBox the value of "Pressed", I will have true and false depending on the button situation but if I change true to false, it does not impact the button situation End Sub Sub GetPressed(control As IRibbonControl, ByRef Pressed) Pressed = False End Sub Any hint?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA upress toggle button in ribbon (ui)

Thread starter Kamolga
Start date Sep 6, 2018
Tags

button false manvalue pressed true

Kamolga

Well-known Member

Sep 6, 2018

Hi,

After hours of readings and tries, I don't get how to change the value of a toggle button to false (not pressed) with VBA.

Code:

Sub TbtnManClick(control As IRibbonControl, [COLOR=#006400]Pressed[/COLOR] As Boolean)
Dim Manvalue As Variant
Manvalue = InputBox(Range("LgMan"), Range("LgMan"), Range("RngMan"))
Range("RngMan") = Manvalue

[COLOR=#ff0000]If I message MsgBox the value of "Pressed", I will have true and false depending on the button situation but if I change true to false, it does not impact the button situation[/COLOR]
End Sub

Sub GetPressed(control As IRibbonControl, ByRef [COLOR=#006400]Pressed[/COLOR])
[COLOR=#006400]Pressed[/COLOR] = False
End Sub

Any hint?