MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Check box control


Posted by Damien O'Donnell on June 14, 2001 11:37 PM

using a check box to reformat a worksheet is great you simply check the value of the check box using vb code
i.e if checkbox1.value = true then whatever
the problem i have is that I can't change the value or state of the check box using vb code do you know how


Posted by JAF on June 15, 2001 4:47 AM

required code

Sub Change_CheckBox_State()
If Me.CheckBox1.Value = True Then
Me.CheckBox1.Value = False
Else
Me.CheckBox1.Value = True
End If
End Sub