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">
        <tabs>
            <tab id="MyTab" label="Button Demo">
                <group id="MyGroup" label="Button Demo">
                    <button id="MyBtn1" size="large" label="Click me"
                      imageMso="BevelShapeGallery"
                      onAction="MyButtonCallbackOnAction"/>
                    <button id="MyBtn2" size="normal" label="Click me"
                      onAction="MyButtonCallbackOnAction"/>
                   </group>
            </tab>
        </tabs>
    </ribbon>
</customUI>

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




Back