Free Entry or List?

  • Thread starter Thread starter NumLock
  • Start date Start date
N

NumLock

Is it possible to configure a cell so that a user can enter EITHER a
value OR select from a list of values? Thanks in advance!
 
Sure...you can create a Data Validation with an Error Alert style of
"Warning" or "Information".
If the user enters a non-list item....a warning will display, but the entry
will still be allowed.

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Or even uncheck the "Show error alert after invalid data is entered" on the
error alert tab.
 

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

Drop-down list and error message 1
combobox 4
Offset and Small functions with blank rows? 0
Multi-select list box 1
IF Statements 3
Dropdown list 3
Excel Message box called if 1 of 3 options is entered. 4
v2003 XML Map, Enumeration to drop-down list 0

Back
Top