Restrict Data Entry in Combo Box

  • Thread starter Thread starter Ripan
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appearance of Data Validation Combo Box 2
Validation list in data entry form 4
hide combo box 6
Graph linked with combo boxes 2
List box or Combo box?? 1
AutoWordSelect in Combo Box Troubles 0
Link cell to combo box 2
Archiving user selection from Drop Down (forms - combo box) 1

Back
Top