Dependent check boxes

[Elijah]

Hi,

I am trying to use a couple of Form checkboxes on a sheet, but I want to
somehow link them together.

For example if the first box is unchecked, then the second check box cannot
be checked. But if the first check box is checked then the second check box
can be either checked or unchecked.

I this possible?, I've tried using IF statements to control which is linked
to the 2nd check box, but the check box doesn't seem to respond to the
result (ie FALSE, TRUE)

Can anyone help? thanks

Elijah

 

[Bob Phillips]

Hi Elijah,

Sub Checkbox1Macro

If ActiveSheet.CheckBoxes(Application.Caller).Value <> xlOn Then
ActiveSheet.CheckBoxes("Check Box 2").Value = xlOff
End If


End Sub
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)