Skip to content

Instantly share code, notes, and snippets.

@andrewcharlesmoss
Last active January 25, 2021 15:53
Show Gist options
  • Save andrewcharlesmoss/d56c99555d39f5997472714d56b963e6 to your computer and use it in GitHub Desktop.
Save andrewcharlesmoss/d56c99555d39f5997472714d56b963e6 to your computer and use it in GitHub Desktop.
'VBA
'Checkbox
Sub chkBox_onAction(control As IRibbonControl, isPressed As Boolean)
'Display status of checkbox in cell: TRUE or FALSE
Sheet1.Range("H9").Value = isPressed
End Sub
<!--XML-->
<!--Checkbox-->
<group id="grp_chkBox" label="Checkbox">
<labelControl id="lblCtrl_dummy1" />
<checkBox id="chkBox" label="View 1" onAction="chkBox_onAction"/>
</group>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment