Prev: Delete entire row if older then 365 days
Next: How do I recover a prior version of a saved document?
From: GEdwards on 3 Apr 2010 19:00
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?

From: Gord Dibben on 3 Apr 2010 20:03
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
<GEdwards(a)discussions.microsoft.com> 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?

From: ozgrid.com on 3 Apr 2010 22:51
Yes, change the Error Alert to Information.



--
Regards
Dave Hawley
www.ozgrid.com
"GEdwards" <GEdwards(a)discussions.microsoft.com> wrote in message
news:75975A08-36AA-412C-9F42-34AAB0348CE4(a)microsoft.com...
>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?
>

From: GEdwards on 3 Apr 2010 22:54
Thanks Gord. This does the work I need and I have also bookmarked the site
you suggested for future reference.

"Gord Dibben" wrote:

> 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
> <GEdwards(a)discussions.microsoft.com> 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?
>
> .
>
From: מיכאל (מיקי) אבידן on 4 Apr 2010 14:32
With all due respect - when the OP asks [quote]:
"...and also allow a user to input their own" - I, and probably 99% of the
supporters in this D.G., would guess he DOES NOT want and/or need ANY KIND of
alert about an "Illegal Value..."
Micky


"ozgrid.com" wrote:

> Yes, change the Error Alert to Information.
>
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "GEdwards" <GEdwards(a)discussions.microsoft.com> wrote in message
> news:75975A08-36AA-412C-9F42-34AAB0348CE4(a)microsoft.com...
> >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?
> >
>
 |  Next  |  Last
Pages: 1 2
Prev: Delete entire row if older then 365 days
Next: How do I recover a prior version of a saved document?