ExcelBanter - Hiding a check box from forms

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hiding a check box from forms (https://www.excelbanter.com/excel-discussion-misc-queries/132175-hiding-check-box-forms.html)

TDC

Hiding a check box from forms

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

joel

Hiding a check box from forms

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

"TDC" wrote:

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

All times are GMT +1. The time now is 08:42 AM.