F Frenchie Dec 15, 2003 #1 How do I check a check box in Excel. I need to know what to put in Private Sub CheckBox1_Click() 'this bit here' End Su
How do I check a check box in Excel. I need to know what to put in Private Sub CheckBox1_Click() 'this bit here' End Su
T Tom Ogilvy Dec 15, 2003 #2 Private Sub CheckBox1_Click() if checkbox1.Value = True then msgbox "box is checked" else msgbox "box is not checked" End if End Sub
Private Sub CheckBox1_Click() if checkbox1.Value = True then msgbox "box is checked" else msgbox "box is not checked" End if End Sub