Need the Value of a Checkbox that does not have a default value of True or False

Hi,

I have a userform with a checkbox on it. In the control properties, I cleared the Value, so it does not appear to be set to True or False. I wasn't sure Excel would let me do this, but it appears to be a valid option. When I run the form, the checkbox now has a grayed out checkmark in the box, rather than being blank for False or a solid black check for True.

I would like to include this grayed out checkbox in my data validations for the userform, but I don't know what the value is to use in an If/Then. I've started writing:

If (me.checkbox.value <> True And me.checkbox.value <> False) Then

But that starts to get messy when I also need to include an clause where the checkbox equals True or it equals False.

I did try to figure it out using the following sub after doing some web research, but the "nothing" if/then turned up an "Invalid use of object" error. So, I commented it out, but the message box for the "null" if/then never popped up.

Private Sub Userform_Initialize()

If Me.checkbox.Value = Nothing Then
MsgBox "value = nothing"
End If

If Me.checkbox.Value = Null Then
MsgBox "value = null"
End If

End Sub

Does anyone know what the value of the checkbox is when it is in its grayed out, no default value state? Any help is greatly appreciated!

Make sure that you have "TripleState" property of the checkbox set to "True".

Then you can check if the value is null like below.

Please Login or Register  to view this content.

Thank you CK76! And thank you doubly for showing me the right way to use null.