Check Box Object Code

[Guest]

Hi All,

I need to create a code to test “Checked†status of a check box on an Excel
Workbook. I’ve placed a Checkbox in an Excel Workbook – Book3 and added the
following code using the add Macro tool. However, I need to add the required
object code.

Sub CheckBox1_Click()

If CheckBox1.Checked = True Then
CheckBox1.Text = "Checked"
Else
CheckBox1.Text = "Unchecked"
End If
End Sub

What’s the code for the ‘required object’?

Thanks
Paul

 

[Douglas J. Steele]

I'd suggest asking in a newsgroup related to Excel.

This newsgroup's for questions about Access, the database product that's
part of Office Professional.