Automatically remove a Combo Box
An ActiveX combobox is both an OleObject and a Shape
Activesheet.OleObject("Combobox1").Delete
Activesheet.Shapes("Combobox2").Delete
A combobox from the forms toolbar is both a shape and an dropdown
Activesheet.Shapes("Drop Down 1").Delete
ActiveSheet.DropDowns("Drop Down 1").Delete
A dropdown from data validation using the list option
ActiveCell.Validation.Delete
ActiveCell.offset(1,0).Select
--
Regards,
Tom Ogilvy
"James" wrote in message
...
I am trying to find out how to automatically remove a combo box after it
is
created. This process needs to be repeatable. i.e. use one combo box
response
to generate a new combo box, then remove the new combo box after the
message
box that pops up from the second box actions have been acknowledged. Then
be
able to repeate the process.
|