OnChange event attached to tick box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jowashy@hotmail.com - 16 May 2008 22:23 GMT

Arrgh please help

I have a spreadsheet that has two tick boxes. The second tick box
mustnt show until the first has been ticked. How do I do it.

Many thanks in desperation

Reply to this Message

Norman Jones - 16 May 2008 23:19 GMT

Hi Jowashy.

Try:

'=========>>
Private Sub CheckBox1_Click()
With Me
.CheckBox2.Visible = _
.CheckBox1.Value = True
End With
End Sub
'<<=========

This is event code and should be pasted
into the worksheets's code module (not a
standard module and not the workbook's
ThisWorkbook module):

Right-click the worksheet's tab |
Select 'View Code' from the menu
Paste the code
Alt-F11 to return to Excel.

---
Regards.
Norman

Reply to this Message

jowashy@hotmail.com - 17 May 2008 08:10 GMT

On May 16, 11:19 pm, "Norman Jones" <normanjo...@wherforartthou.com>
wrote:

> Hi Jowashy.
>
[quoted text clipped - 22 lines]
> Regards.
> Norman

Fantastic. Ill try it immediately. Thanks

Reply to this Message

Britney - 07 Aug 2008 12:39 GMT

Hi Norman
I send you an email as I have the same problem as Jowashy. I tried your code
but it didn't work. Is there any other way to solve this problem

thanks
Britney

> Hi Jowashy.
>
[quoted text clipped - 22 lines]
> Regards.
> Norman

Reply to this Message

FSt1 - 16 May 2008 23:20 GMT

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

regards
FSt1

> Arrgh please help
>
> I have a spreadsheet that has two tick boxes. The second tick box
> mustnt show until the first has been ticked. How do I do it.
>
> Many thanks in desperation

Reply to this Message