Hi,

Im trying to create a spreadsheet with a check box that returns a combo box
when checked, and hide combo box when unchecked. Ive created the following
code for the checkbox, however an €˜Object Required error is returned.

Sub CheckBox1_Click()

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

Does anyone familiar with the €˜Object required code? Also, what line of
code is needed to €˜show and hide the combo box?

Thanks
Paul