hello again,
Thank you for the help!! it worked perfectly!!
however, one more little problem, i saved my work and shut down, but when i
went to reopen and use the check box functions, a help box came up saying
that "to run the macros, you can either have them signed or change your
security level." now i changed my security level to low, and this still did
not help,
Any suggestions on how to solve this problem?

Thank you very much.

Adam

"egun" wrote:

Make sure you are in design mode before you right click. To do that, first
you have to show the Visual Basic toolbar (right click somewhere in the
toolbar area at the top of the window). Then click on the "right angle" icon
- Design Mode. Then when you right click on the check box, you should see
the "View Code" and "Properties" items in the menu.

When you're done, click the Design Mode icon to get out of design mode.

Eric

"Adam H" wrote:

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