Checkbox Macro

[dagindi]

I found the following code which I added to another macro I am working on that inserts a CheckBox:

Please Login or Register  to view this content.

I wanted to alter the above code so that when the check box gets added the text label associated with the text box such as "Check Box 9" gets deleted and the shape gets re-sized.

I used the macro recorder to see how the code should look and I got:

Please Login or Register  to view this content.

How do I recode that macro9AddCBoxes so that when triggered it does the additional formatting in Macro10 without referencing a specific Shape (ActiveSheet.Shapes("Check Box 9").Select)?

Thanks!

[antoka05]

Try with this code:

Please Login or Register  to view this content.

Regards,
Antonio