Skip to content

Instantly share code, notes, and snippets.

@andrewcharlesmoss
Last active January 25, 2021 15:53
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
'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