Turn on Edit option in Combo Box

[Guest]

How do you turn on the Edit option in a Combo Box in Excel 2000? I have no problem entering the drop-down part, but cannot get it to allow editing. Please help.

Pam Williams

 

[Dick Kusleika]

Pam

What kind of combobox? Forms toolbar, Control Toolbox, or Data Validation.

What do you mean by editing? Do you want to edit an entry on the list, add a
new entry to the list, or just be able to type in a value that's not on the
list?

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

How do you turn on the Edit option in a Combo Box in Excel 2000? I have

no problem entering the drop-down part, but cannot get it to allow editing.
Please help.

 

[Guest]

I have a Combo Box from the Forms Toobar in my spreadsheet. The help file said that it can have an entry typed in that is not in the list provided. I cannot type in anything in my drop down box. Should I change it to a combo box from the Conrol Toolbox toolbar?
Thanks, Pam

 

[Dick Kusleika]

Pam

I couldn't find where help said that, but if it does it's fibbing. That's
generally how comboboxes are supposed to work, but for some reason the one's
from the Forms toolbar don't work that way.

You can have that feature with a combobox from the control toolbox. Just
make sure that the MatchRequired property is set to False. I usually use
controls from the Forms toolbar unless there's some specific feature I need
(like this one). The ActiveX controls (Control Toolbox) are quite a bit
different in terms of how you set their properties and run macros from them,
so if you need some information, be sure to post back.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

I have a Combo Box from the Forms Toobar in my spreadsheet. The help file

said that it can have an entry typed in that is not in the list provided. I
cannot type in anything in my drop down box. Should I change it to a combo
box from the Conrol Toolbox toolbar?

 

[Guest]

Thank you. The MatchRequired is what I needed.

Pam

I couldn't find where help said that, but if it does it's fibbing. That's
generally how comboboxes are supposed to work, but for some reason the one's
from the Forms toolbar don't work that way.

You can have that feature with a combobox from the control toolbox. Just
make sure that the MatchRequired property is set to False. I usually use
controls from the Forms toolbar unless there's some specific feature I need
(like this one). The ActiveX controls (Control Toolbox) are quite a bit
different in terms of how you set their properties and run macros from them,
so if you need some information, be sure to post back.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com


said that it can have an entry typed in that is not in the list provided. I
cannot type in anything in my drop down box. Should I change it to a combo
box from the Conrol Toolbox toolbar?

 

[Guest]

Does anyone know how to wrap text if it's too long so it would fit in a drop
down box. I have been going crazy trying to figure this out. My list is
already wrapped in the cell but when I pick it for a drop down list, it does
not show it wrapped, but instead straight on one line so I can't see all the
information. Please help me.

 

[Gord Dibben]

Is this a Data Validation dropdown list?

If so, can't be done.

You could make the column wider.


Gord Dibben MS Excel MVP