If-Clause in VBA to look at checkbox if its checked or not

[zorc]

Hello!

let's say i have "check box 20" and i want to make an IF-clause to check, if this same box is checked or unchecked.

This makes it enabled i have figured out myself yay!

ActiveSheet.Shapes("Check Box 20").Select
With Selection
.Value = xlOn

So Is it possible to make IF-clause to "sniff" that box if its checked or not?

Thanks a million!

 

[Rick Rothstein]

Re: :D

So can the same thing be done for Ovals

What exactly do you mean? Ovals don't have check boxes so what would you be checking for?

 

[Tahas]

Hi friends,

I have an Excel Workbook. It has 26 Sheets. Each Sheet represents Two Week Pay Period.
I have put a Checkbox that (Checkbox 37). I want a macro that would prevent users from SAVING the Workbook without checking the Checkbox. Also, I want macro to prompt ONLY for the Active Worksheet which is being filled by the staff.

Any help will be greatly appreciated.

Kind regards,
Taha