Thread: Dropdown List That Accepts Other User Input
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Dropdown List That Accepts Other User Input
Yes.

Uncheck "Show error alert"

The user-input will not be added to the list permanently.

If you want that you will require some VBA code.

See Debra Dalgleish's site for a sample workbook.

http://www.contextures.on.ca/excelfiles.html#DV0012


Gord Dibben MS Excel MVP

On Sat, 3 Apr 2010 16:00:01 -0700, GEdwards
wrote:

I cannot find if there is a way to have a dropdown list that contains
pre-defined data validation entries and also allow a user to input their own.

Is there a way to do this in Excel?

Reply With QuoteReply With Quote