Clearing Check Boxes

[heidibbb]

Hello,
I've built a form in excel using VB (very new to this). all is working fine, except when the form is filled out and submitted and resets, instead of the check boxes being cleared for the next entry, they all show as checked but greyed out.

I can still fill out the form and check the boxes I want for the next entry, but I want to be able to clear the check boxes so they are empty for the next entry. any ideas?

The code I'm using to clear the form is this... text boxes are clearing fine, it's the check boxes I'm having issues with ("cb_..."). They are technically clearing, but visually, i want them blank:

'clear the data
Me.txtFirst.Value = ""
Me.txtLast.Value = ""
Me.txtTitle.Value = ""
Me.txtSchool.Value = ""
Me.txtAddress.Value = ""
Me.txtCity.Value = ""
Me.txtState.Value = ""
Me.txtZip.Value = ""
Me.txtEmail.Value = ""
Me.txtPhone.Value = ""

Me.cb_SOS.Value = ""
Me.cb_DSCR.Value = ""
Me.cb_DSR.Value = ""
Me.cb_DSFR.Value = ""
Me.cb_SPIRE.Value = ""
Me.cb_ETC.Value = ""
Me.cb_WW3000.Value = ""
Me.cb_MC.Value = ""
Me.cb_MCI.Value = ""
Me.cb_AOR.Value = ""

Me.cb_AdoptScience.Value = ""
Me.cb_AdoptMath.Value = ""
Me.cb_AdoptLiteracy.Value = ""
Me.cb_AdoptNone.Value = ""

Me.cb_SalesYes.Value = ""
Me.cb_RaffleYes.Value = ""

Me.txt_Comments.Value = ""

I'm sure this is probably an easy answer... but like I said... I'm new at this!

thanks!

 

[Norie]

Are the checkboxes linked to cells?

 

[djreiswig]

Instead of setting them to a value of "" set them to False. Then they will be unchecked and not grayed out.

 

[heidibbb]

Yes, they are linked to cells in an excel spread sheet

 

[heidibbb]

FALSE is working

Thank you!!! I knew it would be so simple.

 

[Praedico]

Instead of resetting each individual checkbox to false you could try:

    For Each Control In UserForm1.controls
      If TypeName(Control) = "CheckBox" Then
          Control.Value = False
      End If
    Next control

I have this placed into the code after the data is placed on the spreadsheet from the userform. Obviously you'll have to change "UserForm1" above to whatever yours is called.

Hope that helps