Disableing a check box when another is checked

I have created a spread sheet that combines several option for a house into one total. I have used checkboxes to pull the numbers into a "Master Sheet" but I would like to have certain checkboxes unavalibe if others are checked so you can not pick options that do not work together. I know nothing about VBA but would like to figure this one out. It's in Excel 2003

Hi!

You could start here:

Open the Visual Basic help file (right click on a sheet tab: select View Code: press F1 or use the Help button.

Enter Checkbox and search. Among the items offered you should find Checkbox Control (Forms).

Probably enough to get you going. Come back if it raises problems.

Alf

Thanks that was a start. But I found this which disable one and enables the other.

Private Sub CheckBox2_Click()

If CheckBox2.Value = True Then
CheckBox3.Value = False
CheckBox3.Enabled = False
CheckBox7.Enabled = True
CheckBox7.Value = False
Else
CheckBox3.Enabled = True
CheckBox3.Value = False
CheckBox7.Enabled = False
CheckBox7.Value = False
End If

End Sub