CheckBox value is null then skip the macro

[sdsurzh]

Hi,


I have create 4 CheckBoxes if all the four CheckBoxes are not checked then the macro(already i have) should not run and it should through error message "Please select the above option". Please provide a code of me.


Thanks,

Suresh Kumar S

 

[Hui]

Suresh


It depends on what type of Check box you have used


Active X Control Check Box


If CheckBox1.Value = True and CheckBox2.Value = True and CheckBox3.Value = True and CheckBox4.Value = True Then Exit Sub


Form Control Check Box

With these link to the cell link reference

Assumed to be A1:A4 in this example


If Range("A1").Value = True and Range("A2").Value = True and Range("A3").Value = True and Range("A4").Value = true Then Exit Sub