Excel combo box edit

R

R Ormerod

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?
 
J

Jim Rech

Change the Style property to fmStyleDropdownList.

--
Jim
|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
 
Top