Archive of Mr Excel Message Board


Back to Controls in Excel archive index
Back to archive home

Annoying little problem!! Please could you help.

Posted by Anna Daly on December 20, 2000 7:55 AM
Hi All,

Just a quick problem that I was hping one of you could help me with. I have set up a command bar tha contains a combobox allowing the user to select an item from the list. Is there any way of preventing the user from editing the text in the combobox. At the minute the user is able to edit the text in the combobox and if they change the text to a value that is not predefined in the combobox list then the macro crashes as it can not find a match.

kind regards,

and a Merry Christmas

Anna



Re: Annoying little problem!! Please could you help.

Posted by Tim Francis-Wright on December 20, 2000 9:11 AM


Just a thought:
Wouldn't a listbox instead of a combobox do
exactly what you need? It takes the combo
out of the combobox.

--tim


Re: Annoying little problem!! Please could you help.

Posted by cpod on December 20, 2000 9:35 AM

Go to the properties list for the combo box and change "style" from dropdowncombo to dropdownlist



This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.