MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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.


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