Check Box troubles

[jimayers]

Hello - I could use some help. I am not understanding how to use checkbox's.
I would appreciate any help or advise on why the following code doesn't work. I get an "Object Required" error when it comes to the checkbox.2

If sh.Name = "Waiting List" Then
        [COLOR=#0000ff]If CheckBox2.Value = False [/COLOR]Then GoTo a
        Call UpDatebyDR_EdRoster_BHousing_NO_Sort
        Call count
        MsgBox (sh.Name & " updated.")
        GoTo a
End If

The full code is:

Sub UpDate_Workbook()
Application.ScreenUpdating = False
Dim MacroWb As Workbook
Dim sh As Worksheet

Set MacroWb = Workbooks("MACROS-Student List_3.xlsm")

For Each sh In MacroWb.Worksheets
    If sh.Name = "SMs" Then GoTo a
    If sh.Name = "Yard" Then GoTo a
    If sh.Name = "Waiting List" Then
        [COLOR=#000080]If CheckBox2.Value = False [/COLOR]Then GoTo a
        Call UpDatebyDR_EdRoster_BHousing_NO_Sort
        Call count
        MsgBox (sh.Name & " updated.")
        GoTo a
    End If
    If sh.Name = "FULL Class List" Then
            If CheckBox2.Value = True Then Call UpDatebyDR_EdRoster_BHousing 'trying different way, using true not false
        MsgBox (sh.Name & " updated.")
        GoTo a
    End If
    If sh.Name = "TABE" Then
        If CheckBox2.Value = False Then GoTo a
        Call UpDateTABE
        MsgBox (sh.Name & " updated.")
        GoTo a
    End If

    If CheckBox2.Value = False Then GoTo a
    Call UpDatebyDR_EdRoster_BHousing
     MsgBox (shName & " updated.")
    End With
a:
Next sh
Application.ScreenUpdating = True
End Sub

Thanks for any help or explanation - Jim A

 

[Norie]

How did you create the checkbox and where is it located?

 

[jimayers]

How did you create the checkbox and where is it located?

I copied/pasted the check box in every sheet that needs it.

 

[Rick Rothstein]

I copied/pasted the check box in every sheet that needs it.

What kind of Checkbox is it... Forms or ActiveX ?

 

[jimayers]

What kind of Checkbox is it... Forms or ActiveX ?

Forms....and I dont realy know the difference of why I might use one over the other.

 

[Rick Rothstein]

Forms....

Try changing the line of code you highlighted in Message #1 to this and see if it works for you...

If sh.Checkboxes("Check Box 2").Value = False Then GoTo a

Note: I assumed you did not change the default name of the Checkbox, which is "Check Box 2", not CheckBox2 like you referred to it as. If you did change the name from its default, then use that in place of what I highlighted in blue.

 

[jimayers]

Note: I assumed you did not change the default name of the Checkbox, which is "Check Box 2", not CheckBox2 like you referred to it as. If you did change the name from its default, then use that in place of what I highlighted in blue.

I used "CheckBox2" because that is how it is listed in the properties box without any modifications by me. ????

 

[jimayers]

Try changing the line of code you highlighted in Message #1 to this and see if it works for you...

If sh.Checkboxes("Check Box 2").Value = False Then GoTo a

No luck...

 

[Norie]

If when you right click the checkbox you have the option Properties it's an ActiveX checkbox not a Forms checkbox.

 

[jimayers]

If when you right click the checkbox you have the option Properties it's an ActiveX checkbox not a Forms checkbox.

Ah...sorry.
It must be an ActiveX checkbox then.