Checkbox - onAction

 

CheckBoxThe callback sets the checkbox value when clicking the checkbox.

 

 



Sample Ribbon XML file: 

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="CallbackOnLoad">
    <ribbon startFromScratch="false">
        <tabs>
            <tab id="MyTab" label="Sample CheckBox">
                <group id="MyGroup" label="Sample CheckBox" >
                    <labelControl id="myLabel1" label="Sample:" />
                    <labelControl id="myLabel2" label="Checkbox" />
                    <checkBox id="MyCheckBox" label="My CheckBox" 
                      getPressed="MyCheckBoxCallbackGetPressed"
                      onAction="MyCheckBoxCallbackOnAction" />
                
                </group>
            </tab>
        </tabs>
    </ribbon>
</customUI>

Function to be copied to a standard module:

Sub MyCheckBoxCallbackOnAction(control As IRibbonControl, _
                               pressed As Boolean)
    ' Callback Checkbox Click
    Select Case control.ID
        Case "MyCheckBox"
            MsgBox "Checkbox Value" & control.ID & _
                   " : " & pressed, vbInformation, _
                   "CheckBox Sample"
    End Select
End Sub



You can find this sample in Sample DB 2




Back