View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.