Can't get rid of combo box

[mjones]

Hi,

I followed these instructions from a previous post, but it didn't help.

Edit>Go To, click Special
Select Objects, click OK
Press the Delete key, to delete any objects that were selected. (no
objects were selected)

If that didn't work, it may be an object from the control toolbox:
(yes, it was)
Choose View>Toolsbars>Control toolbox
Click the Design mode button
Point to one of the lines
If the pointer changes to a four-headed arrow, click on the line to
select it (it didn't change to a four-headed arrow)
Press the delete key, to delete the line

I also used the arrow in the Drawing toolbar to lasso it, but the
border just disappears when I release the mouse.

Any other ideas please! When I click on it, I only get the dropdown
with nothing in it. Double click does nothing. There's a combobox1
object in VB but I can't seem to delete it.

Thanks,

Michele

 

[Dave Peterson]

If it's a combobox from the Control toolbox toolbar and you can find out the
name, you could use this from the immediate window within the VBE:

ActiveSheet.OLEObjects("combobox1").Delete

 

[glenton (glenton]

Hi

Are you sure that you've entered design mode? The design mode button should
look inset. If so, and it still doesn't change to 4-arrows then it probably
wasn't a control toolbox.

It could be a form combobox, in which case try right clicking it and then
press escape and then delete (this is the built-in forms which you access
from the forms menu in excel, rather than the user forms in VB).

It could conceivably be a validation combobox?! I doubt it, but then select
the cell where the combobox is, and go data-validation-allow-any value.

Otherwise it can only be some sort of user-define form in VB. If so it's
presumably got ShowModal set to false. I also really doubt that it's this,
because you should be able to close it with the top right button.

Let us know if you're still having trouble.

Glenton

 

[mjones]

Thanks Glenton. I was able to delete it finally, although I can't say
what the problem was. I exited Excel and opened the file again and
then I was able to click on it, seeing the four white circles on the
corners, I highlighted and deleted it. Something must have been set
that cleared.

(e-mail address removed)