| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding a check box from forms
How can I use option buttons from forms to hide then unhide a check box from
forms? Thoughts? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forms/ Check Box | Excel Discussion (Misc queries) | |||
| check boxes from the forms tool bar | Excel Worksheet Functions | |||
| hiding forms button | Excel Discussion (Misc queries) | |||
| Check box in Forms Toolbar | Excel Discussion (Misc queries) | |||
| check off, look up forms - VERY confused | Excel Discussion (Misc queries) | |||
Linear Mode
