Check Box Show Hide

[Guest]

Hi,

I’m trying to create a spreadsheet with a check box that returns a combo box
when checked, and hide combo box when unchecked. I’ve 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

 

[Bob Phillips]

Try .Value instead of .Text for the test, and .Caption when setting it.

--

HTH

RP
(remove nothere from the email address if mailing direct)