Free Entry or List?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NumLock - 09 Apr 2008 18:02 GMT

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!

Reply to this Message

Ron Coderre - 09 Apr 2008 18:24 GMT

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)

> 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!

Reply to this Message

Dave Peterson - 09 Apr 2008 18:49 GMT

Or even uncheck the "Show error alert after invalid data is entered" on the
error alert tab.

> Sure...you can create a Data Validation with an Error Alert style of
> "Warning" or "Information".
[quoted text clipped - 13 lines]
> > 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!

Signature

Dave Peterson

Reply to this Message