Checking all checkboxes on a worksheet

[shivboy]

Hi,

Have created a small form with 5 checkboxes and a button on a worksheet. Want to check all checkboxes on the worksheet when the button is pressed.

However, I am getting "Run-time error '438': Object doesn't support this property or method". Enclosing the code for your reference.

Please Login or Register  to view this content.

Any help is highly appreciated.

[Leith Ross]

Hello shivboy,

Please update your user profile to include which version or versions of Office your using.

Which type of Check Boxes are you using: Forms or ActiveX?

[shivboy]

Hi Leith,

I am using Office 2010. I have used ActiveX controls on the sheet.

Hello shivboy,

Please update your user profile to include which version or versions of Office your using.

Which type of Check Boxes are you using: Forms or ActiveX?

[Leith Ross]

Hello shivboy,

Thanks for updating your profile. It makes it easier to answer questions knowing which Office versions you are using.

This macro will check all the ActiveX CheckBoxes on the ActiveSheet.

Please Login or Register  to view this content.

[shivboy]

Thanks, Leith. This is very useful.

Just one more query. If I wanted to check if any 2 of those 5 checkboxes have been checked, is it possible to do that using the same logic?