ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can you hide forms checkboxes (https://www.excelbanter.com/excel-programming/287383-can-you-hide-forms-checkboxes.html)

matt

Can you hide forms checkboxes
 
Can you hide forms checkboxes based on whether another forms checkbox is selected? If so, where do I need to put the code(Worksheet or Workbook)? Thanks.

Ron de Bruin

Can you hide forms checkboxes
 
Hi Matt

I advise you to use the checkboxes from the control toolbox.
You have much more control then.

You can use this in the Sheet module

Private Sub CheckBox1_Click()
If Me.CheckBox1.Value = True Then
Me.CheckBox2.Visible = False
Else
Me.CheckBox2.Visible = True
End If
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Matt" wrote in message ...
Can you hide forms checkboxes based on whether another forms checkbox is selected? If so, where do I need to put the

code(Worksheet or Workbook)? Thanks.



Dave Peterson[_3_]

Can you hide forms checkboxes
 
see one more reply to your other post for some forms code.

Matt wrote:

Can you hide forms checkboxes based on whether another forms checkbox is selected? If so, where do I need to put the code(Worksheet or Workbook)? Thanks.


--

Dave Peterson



All times are GMT +1. The time now is 07:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com