Button - onAction


Button Demo This callback will be performed when clicking the ribbon control. The function does not return any values.



Sample Ribbon XML file:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="CallbackOnLoad">
    <ribbon startFromScratch="false">
            <tab id="MyTab" label="Button Demo">
                <group id="MyGroup" label="Button Demo">
                    <button id="MyBtn1" size="large" label="Click me"
                    <button id="MyBtn2" size="normal" label="Click me"

Function to be copied to a standard module:

Sub MyButtonCallbackOnAction(control As IRibbonControl)
' Callback Ribbon Button Klick
    Select Case control.id
        Case "MyBtn1"
            gobjRibbon.InvalidateControl "myLabel1"
            gobjRibbon.InvalidateControl "myLabel2"
        Case Else
            MsgBox control.id & " click"
    End Select
End Sub


You can find a sample in Sample DB 2