Cannot delete a combo box - HELP!

[cyberkev]

I've got a spreadsheet where I created a number of combo
boxes. Now I no longer need them, but I can't delete
them. I can select the combo box by right-clicking it,
but then Delete has no effect. If I cut and paste, it
makes the new combo box, but the original remains and then
*both* cannot be deleted. Any suggestions on how to get
out of this?

-- Kevin

 

[Tom Ogilvy]

did you try right clicking on it and select Cut.

 

[cyberkev]

It turns out I had *hundreds* of combo boxes on top of
each other. (Some weird glitch with Excel, it seems.)
My "failed deletes" were actually successful and were
revealing the next identical combo down the list.

I also found a way to remove ALL of the combo boxes on a
worksheet at one time:

make the worksheet with the checkboxes the active sheet
Hit alt-F11 to see the VBE.
Then hit ctrl-G to see the immediate window
type this in
ActiveSheet.DropDowns.Delete
hit enter

Cheers,

Kevin


=>-----Original Message-----

 

[Ken Wright]

You could also have done Edit / Go To / Special / Objects and then hit the
Delete button, though this would have deleted ALL objects on the sheet.