Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2006

Tip: Looking for answers? Try searching our database.

Can't get rid of combo box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mjones - 15 Sep 2006 20:47 GMT
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 - 15 Sep 2006 21:20 GMT
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

> Hi,
>
[quoted text clipped - 24 lines]
>
> Michele

Signature

Dave Peterson

glenton (glenton@leviqqio.com - 15 Sep 2006 21:24 GMT
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

> Hi,
>
[quoted text clipped - 24 lines]
>
> Michele
mjones - 16 Sep 2006 19:36 GMT
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.

glenton@leviqqio.com
<glentonglentonleviqqiocom@discussions.microsoft.com> wrote:
> Hi
>
[quoted text clipped - 45 lines]
> >
> > Michele
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.