Combo box possibility?

  • Thread starter Thread starter kildevil
  • Start date Start date
K

kildevil

Is it possible to configure a combo box to allow the user to eithe
select from a drop down list or directly enter data into the comb
boxes area? Ex. The choices for leader are Tony, Timmy, & Tommy.
Today, Mary needs to lead. Can unexpected data be entered?

Is it possible to conditionally format a cell using the result o
selecting a name from the above combo list. Ex. If Tommy is selecte
from the combo list, a cell with "SWIMMING" entered turns RED. (Tomm
can't swim and should not lead us in swimming)

Thank you

Do
 
If you use a combo box from the Forms toolbar, you can't type in it. If
you use a combo box from the Control Toolbox, you can select an item
from the dropdown list, or type any entry in the combo box.

Or, if you're using a data validation dropdown (Data>Validation), you
can remove the check mark on the Error Alert tab, and type any entry in
the cell.

You could turn other cells red, based on the selection in a data
validation cell, or the linked cell for a combo box.
 
Back
Top