hiya,

thanks a lot for that but it doent seem to work with the version of excel i
am using, i am using microsoft office excel 2002. do i need to update the
software before being able to do this?? when i right click on the check box,
the only options are cut, copy, paste, edit text, grouping, order, assign
macro, and format control.

Hope this makes it clearer.

Thanks again

"egun" wrote:

I added two checkboxes to a worksheet, with default names, in design view.
Right click on CheckBox2 and select Properties. In the Properties window,
select False for the Visible property.

Right click on CheckBox1 and select View Code. In the Click event that is
automatically created, use the following code. It will change the visibility
of CheckBox2 according to the value of CheckBox1.

You could also use the Enabled property for CheckBox2, if you wanted to keep
it visible but didn't want to allow the user to change its value unless
CheckBox1 is True.

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

HTH,

Eric