View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jowashy@hotmail.com is offline
external usenet poster
 
Posts: 2
Default OnChange event attached to tick box

On May 16, 11:19 pm, "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


Fantastic. Ill try it immediately. Thanks