Temperamental Macro's: Errors occur if any changes are made

[henryBukowski]

This is driving me mad.

I have a series of Macro's which, thanks to some help from this forum, were working perfectly.

An example:

Please Login or Register  to view this content.

The Macro checks that at least one check-box in a range has been ticked, and returns an error if that is not the case.
However. If I attempt to replicate this Macro but for a different range of check-boxes, by copying the code into a new module and changing the numbers, I.e

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

I suddenly am getting an error message(s):

Unable to get the value property of the checkbox class.
OR
method checkboxes of object _worksheet failed

What has changed!?

I have a feeling there is something going on around where my macro's are saved and stored. But it doesn't work even if the module is hosted in my Personal.xls file.

I would really appreciate it if somebody could shed light on this for me. This place is becoming like my second home...

[Norie]

Are the checkboxes all of the same type?

[henryBukowski]

Are the checkboxes all of the same type?

Interesting point - but none of them have =EMBED (or whatever it is for ActiveX) - So I think they're all Form control

[Norie]

You asked a question 'What has changed?".

Can I ask a slightly different question?

What's different about the checkboxes/code that's causing the errors?

[henryBukowski]

You asked a question 'What has changed?".

Can I ask a slightly different question?

What's different about the checkboxes/code that's causing the errors?

So the other range of check-boxes is much bigger and in a jumbled order, presumbly because I copied and pasted them to generate new ones.

I suppose it's possible that even though the boxes cover the range number 653 - 694, there may be one number in the middle of the range which is missing.

However, to illustrate my query whether it was macro location:

When RomperStomper helped me adjust my code to make it work, he said 'It now works'.
I tried it in my client sheet, and came back with 'No it doesn't'
He then came back and said 'yes it does'

So I started a new workbook, created 5 check-boxes, pasted in the code, and hey it worked.

So it seems to be something about my current workbook

[romperstomper]

Are you sure you have the correct names for the checkboxes, and that you haven't grouped any controls?

[henryBukowski]

Are you sure you haven't grouped any controls?

Hello again,

I'm unsure what you mean? However, I have grouped all the check-boxes so that if one moves the others move and they all stay together, like you would want in a user/client form.

Is this a big no-no?

[romperstomper]

That is almost certainly why you can't read the values, unfortunately.

[henryBukowski]

It wouldn't be a massive deal if there was an alternate way to make sure the boxes don't get moved around?

Ultimately I want people to be able to check or uncheck the boxes, but not move around or resize - if there was another way to do this, I wouldn't mind at all about not grouping them.

[romperstomper]

You could protect the worksheet, or use a userform, or use an alternative to checkboxes (e.g. a Marlett font applied to cells).