VBA/Excel/Access/Word/Forms/CheckBox

CheckBox returns a True value when checked, or a False value if not.

   <source lang="vb">

    Private Sub CheckBox1_Click()
        If CheckBox1.Value Then
            Range("B1").Value = 0.33
        Else
            Range("B1").Value = 0.3
        End If
    End Sub
</source>
   
  

Check various properties of the controls and take appropriate actions

   <source lang="vb">

Sub check()

 If CheckBox1.Value = True Then Call yourModule

End Sub

</source>
   
  

Makes CheckBox control appear with a check mark:

   <source lang="vb">

Sub value()

 UserForm1.CheckBox1.Value = True

End Sub

</source>