Combo Box Limits Data Entry

  • Thread starter Thread starter The Merg
  • Start date Start date
T

The Merg

I currently have a spreadsheet in Excel 2003 that has multiple cells
designated as combo boxes. The data for the combo boxes comes from named
lists elsewhere in the workbook. Although I want the the combo boxes to be
populated from data from these lists, I would also like to allow the user to
enter in a value that might not be in the list. Is there a way to do this
that I am missing?

Thanks,
Merg
 
You can do this with a combo box from the control toobox, or, use the list
option of data validation and disable the alert message.
 
Back
Top