Restrict Data Entry in Combo Box

R

Ripan

Is there any way to prevent a user from typing into a Combo Box and onl
selecting items by selecting them from the drop down menu? I'm tryin
to reduce data entry errors from the user.

Thanks a lot,

Ripa
 
H

hmws

Hi

If your list is "fixed" could you not just create a list
in a worksheet and use Data > Validation > Allow > List
(Select your list range).

It produces a drop-down list similar to your combo-box
and the user can't change any entries.
 
Top