CheckBox returns a True value when checked, or a False value if not. : CheckBox « Forms « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Forms
  3. CheckBox

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

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








Related examples in the same category

1.Makes CheckBox control appear with a check mark:
2.Check various properties of the controls and take appropriate actions