VBA code to disable check boxes based on values

[Chris Shepherd]

Hi,

I am looking for a VBA code that when the sheet is activated, disables check boxes based on a conditional values.

I have used form check boxes (Check Box 36 to Check box 60) and have a column of true/false vales (Y3:Y27).

What I would like is when the sheet is selected, it loops through all the check boxes and disables them if the appropriate value is false.

Thanks,

Chris

[davesexcel]

You are missing a very important part of your question.
That is

disables them if the appropriate value is false.

What do you mean by this?

[Chris Shepherd]

Dave,

What I mean is for each of the check boxes, there is a corresponding value in column y that determines whether the check box is to be enabled or disabled based on other conditions.

[Leith Ross]

Hello Chris,

Here is a macro that will run each time the worksheet is activated.

To add the Macro

1. Copy the macro code
2. Select the worksheet the check boxes are on.
3. Right Click the Tab and select View Code....
4. Paste the macro code and save the changes

Please Login or Register  to view this content.

[Chris Shepherd]

Leith,

Thanks for the code, however, when I select the sheet I get the following error code: Run-time error '1004' Unable to get the CheckBoxes property of the Worksheet class.

When I debug it highlights

Please Login or Register  to view this content.

I just changed the code to the following and it now works.

Please Login or Register  to view this content.

Thanks again

Chris

[Leith Ross]

Hello Chris,

Sorry, I forgot to add a space after "Box". The line should be...

Please Login or Register  to view this content.

[Chris Shepherd]

Leith,

I just figured it out too

Chris