Excel combo box edit
 

I have set up a combo box in Excel with a list fill range.

How do I prevent manual editing of the Combo Box contents so that only the
values specified in the list can be selected?

--
R Ormerod

Excel combo box edit
 

Change the Style property to fmStyleDropdownList.

--
Jim
"R Ormerod" wrote in message
...
|I have set up a combo box in Excel with a list fill range.
|
| How do I prevent manual editing of the Combo Box contents so that only the
| values specified in the list can be selected?
|
| --
| R Ormerod