clear a check box when a option button is selected

[bademployee]

Hi all

I have option buttons 1 & 2 linked on a sheet, also have a check box relevent to option button 2.

Simply, all I want to do is clear the check box when option button 1 is selected.

Thanks for any help in advance.

Mark

 

[Jaye7]

The following will work, just paste it into your module and change the check box if necessary.

ActiveSheet.Shapes.Range(Array("Check Box 1")).Select
    With Selection
        .Value = xlOff
 
    End With