Delete Radio Buttons & Check Boxes

[Smurfit-Stone]

Hello Board,
Is there a way to delete or get rid of a large amount of radio buttons from a spreadsheet? I have a spreadsheet with two radio buttons per row and 435 rows. I've deleted and cleared the columns but the button are still there.....there has to be a way to get rid of them except one at a time....Thanks in advance

 

[Andrew Poulsom]

You could do it with VBA. Where are the OptionButtons from - Control Toolbox or Forms Toolbar?

 

[daniels012]

Try this:

Create this Macro:

Sub EraseSelectedSymbols()
    Dim isect As Range
    For Each PicObj In ActiveSheet.Shapes
        TheLeft = PicObj.TopLeftCell.Address
        Set isect = Application.Intersect(Range(TheLeft), Selection)
        If Not isect Is Nothing Then PicObj.Delete
    Next PicObj
End Sub

You can even assign it to a button if you like.

You never said which 2 columns but, highlight the 2 columns and then start this code. This will delete all shapes(buttons) in the 2 columns.
If you need to just delete up to the 435 row, then just select up to this row.

Hope that helps,
Michael

 

[Lewiy]

In design view, click on the arrow (selection) button on the drawing toolbar, then you can drag a box around all of the objects you want to delete and then press Delete.

 

[Smurfit-Stone]

Thanks Daniel....it worked. Manager changed his mind about radio buttons, he decided he might want to do a sort later in future and buttons wouldn't work...thanks again EVERYONE!

 

[daniels012]

Lewiy
WOW!
I have always been curious why this task was not easier. And now to find out, the task is much easier with your suggestion

I always learn so much from this site!!!
ray: ray: ray:

Thank you,
Michael

 

[Norie]

You could also use Edit>Goto...Special and select Objects, then hit delete.

But my personal favourite(s) would be just to either delete the sheet, or just copy the data only to another sheet.

 

[SAS_girl]

Six years later and this was still useful for me on Excel 2010! Thanks so much. Was copying/pasting information from HTML and trying to get around the buttons was crazy.

For others reading, Daniels012's macro - all I did was copy, went to create macro, dropped into the code box. Highlighted the section I wanted to apply to and clicked run. So easy!!

Thanks again!