Combo box is undeletable

[Aardvark]

Anyone met this before? It cannot be selected so cannot be deleted. Using
the draw tool does not work. Other combo boxes, no problem. Odd

Thanks,

Danny

 

[Earl Kiosterud]

Danny,

Can you select it holding Ctrl?

 

[Aardvark]

nope :-(

Danny,

Can you select it holding Ctrl?

 

[Dave Peterson]

Are the comboboxes you can select really dropdowns from the Forms toolbar?

And the combobox you can't select from the Controltoolbox toolbar? If you show
the ControlToolbox toolbar, you can go into design mode and see if you can
select it then.

 

[Aardvark]

Dear Mr Peterson,

That was clever...and it worked It did make me think though, what is
the difference between the drop down in the forms toolbar and the drop down
in the Control toolbox toolbar?

Many thanks,

Danny

 

[Dave Peterson]

I find the controls from the Forms toolbar easier to work with. But the
controls from the control toolbox toolbar have a bunch of properties that you
can modify.

Right click on a combobox from the controltoolbox toolbar and select
properties. You'll see a bunch.

Right click on a dropdown from the Forms toolbar and you'll see Format control.
And an extra tab on that dialog that allows you to assign an input range and
linked cell.

(Those kinds of things appear in the properties of the combobox.)

You can assign the same macro (probably in a general module) to different items
(maybe similar types--like all dropdowns or all checkboxes).

With controls from the control toolbox, the code lives under the worksheet that
owns the object.

In particular, what's returned from a dropdown is an index into the list. The
value returned from combobox is, er, the actual value that appears in the
combobox.

And the controls from the control toolbox toolbar are the "new and improved"
version of controls. The Forms controls are supported for backward
compatibility (and to make my life easier). (In fact, the forms stuff is hidden
in the object brower. You actually have to ask to see them.)