-
Solved: CheckBox Delete in Macro
I added a checkbox in a macro Set abc = .Shapes.AddFormControl(xlCheckBox, 270, 313 + stu* 16, 100, 0) (actually 4, since this sits in a loop) and would like to have them display a different name (like, not 'Checkbox 13') and then I would like to delete them . I'm not very familiar with these, so any assistance would be greatly appreciated.
Thank you,
Matt
Last edited by mferrisi; 03-22-2007 at 12:04 PM.
-
Can you post your full code. What do you want to call them and how do you want to delete them?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
[vba] Set abc = .Shapes.AddFormControl(xlCheckBox, 270, 313 + stu * 16, 100, 0) abc.Name = "My Checkbox" abc.Delete [/vba]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules