View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default Allow list OR custom text?

Haha - thanks! Can't believe I missed that!


"Dave Peterson" wrote:

Plain old data|validation will work.

Show that dialog. You can choose what should happen if the user types something
not on the list--stop, warning, information.

You can also just uncheck that "show error alert after invalid data is entered"
box.

Dan wrote:

Hi,

Is there a way to have a cell offer both the user-selectable list similar to
what is achieved through data validation as well as giving them the option to
enter in their own value if none of the predefined choices fits their needs?

Could this be accomplished via a custom data validation or a formal?

Thanks!
-Dan


--

Dave Peterson