I found the following code which I added to another macro I am working on that inserts a CheckBox:
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:
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!
Bookmarks