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
