Why is VBA Excel not finding checkbox object?

[rosshughson]

I have added 4 checkboxes to a spreadsheet and want my macro to check the value of each one. When I step through the macro to the If statement below, I get an error message saying that the object is required. I'm new to VBA and not sure if the problem is there or on the Excel side.

If CheckBox1.Value = False Then

I have tried putting the spreadhsheet name in front of the checkbox name

eg - If MAIN.CheckBox1.Value = False Then

but that didn't help. What am I doing wrong??

[QVeen72]

Try :
Worksheets("Sheet1").CheckBox1.Value
OR
ActiveSheet.Checkboxes("CheckBox1").Checked = False
OR
ActiveSheet.Checkboxes(1).Checked = False

[Guido Geurs]

I'm using excel 2003 and it's working for me with: (see attachment).

Private Sub CommandButton1_Click()
   If CheckBox1.Value = True Then
      MsgBox ("1")
   ElseIf CheckBox2.Value = True Then
      MsgBox ("2")
   ElseIf CheckBox3.Value = True Then
      MsgBox ("3")
   ElseIf CheckBox4.Value = True Then
      MsgBox ("4")
   Else
      MsgBox ("Select a checkbox !")
   End If
End Sub
 

br,

[rosshughson]

Thanks QVeen72. When I included the worksheet name in the format you indicated it worked with no problems.

[rosshughson]

@QVeen72
HI. When I specified the worksheet name in the format you specified it worked with no problems. Thanks for your help.