Excel userform checkboxes null

Question

I have created a userform and added a chekcbox called 'DSSSContact'. I have written some code to check the contents of the userform before saving in the following sub:

Private Sub SaveandClose_Click()

When the form is initialized the checkbox is set greyed out but ticked - which I think means the value is null. The SavandClose sub code includes the following which I thought would make sure that checkbox is either set to true or false:

If DSSSContact = Null Then
MsgBox "DSSS Contact Test"
Exit Sub
End If

However when I save and close the form using the save and close command button without having made a selection on the checkbox the form saves the contents without triggering the message box. All the other checks that I have created to verify that textboxes and combo boxes are populated are working fine. I have also added the following code within the same sub:

Debug.Print Me.DSSSContact.Value

This prints null in the Immediate window

Any help much appreciated. Thanks

barryleajo · Accepted Answer · 2014-12-22 22:15:09Z

1

Try

If IsNull(DSSSContact.Value) Then

edited Dec 22, 2014 at 22:15

answered Dec 22, 2014 at 17:10

barryleajo

1,9622 gold badges13 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

causita · Accepted Answer · 2014-12-22 16:56:52Z

0

Check boxes in the forms are True = checked or False = Unchecked.

sub test()
    MsgBox DSSSContact.Value
    If DSSSContact.Value = "False" Then
    MsgBox "DSSS Contact Test"
    Exit Sub
    End If

end sub

answered Dec 22, 2014 at 16:56

causita

1,7181 gold badge24 silver badges35 bronze badges

Collectives™ on Stack Overflow

Excel userform checkboxes null

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related