Check Box Show Hide

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Try .Value instead of .Text for the test, and .Caption when setting it.

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top