The 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