Hiding a check box from forms

G

Guest

How can I use option buttons from forms to hide then unhide a check box from
forms? Thoughts?
 
G

Guest

If the check box is on a worksheet these commands work
Worksheets("Sheet1").Shapes("Check Box 1").Visible = False

Worksheets("Sheet1").Shapes("Check Box 1").Visible = True

If the check box is on a uses form in VBA use this format.

UserForm1.CheckBox1.Visible = False
UserForm1.CheckBox1.Visible = True
 

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

Similar Threads

Need to password protect work sheet and unhide rows. 2
Check Boxes In Excel 2
Unhide Multiple Sheets 2
Check box reversal 2
Hide and unhide...what the heck!!?? 6
Hide option buttons 2
Spellchecker anomaly... Checks spelling on a Forms Button text label...? 6
How to Hide and Unhide Rows 2

Top