PDA

View Full Version : Solved: CheckBox Delete in Macro



mferrisi
03-22-2007, 11:28 AM
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

mdmackillop
03-22-2007, 03:01 PM
Can you post your full code. What do you want to call them and how do you want to delete them?

Bob Phillips
03-22-2007, 03:29 PM
Set abc = .Shapes.AddFormControl(xlCheckBox, 270, 313 + stu * 16, 100, 0) abc.Name = "My Checkbox" abc.Delete