OnChange event attached to tick box
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
"Norman Jones" wrote:
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
|