Solved: Triple Value Check Boxes

[ProteanBeing]

I have a checkbox (let's call it CB1) that is set up for triple value. I know that the greyed value is null but when I attempt to use an if statement:

[VBA]if CB1.value=null then
' Enter code
end if[/VBA]

I get an "Invalid use of Null" error. I then tried this:

[VBA]if CB1.value is null then
' Enter Code
end if[/VBA]

And I got an "object required" error. I'm at a loss for how to do this. Please help.

[ProteanBeing]

Nevermind. I got it. For those who were curious there is a function called IsNull(value) that returns a boolean.