Hi,

I am having difficulty in adding new enteries to my data validation list,
every time I try to enter a new entry on the list it starts to over write my
existing enteries. Does anyone know if there is a maximum number of
characters allowed per drop down!? Or does anyone know how to get around this
problem!?

Thanks,

C

Put the values in a range, and point the DV at that range rather then embed
them.

--
__________________________________
HTH

Bob

"Davieslondon" <(E-Mail Removed)> wrote in message
news:419F83B8-F99B-457C-B386-(E-Mail Removed)...
> Hi,
>
> I am having difficulty in adding new enteries to my data validation list,
> every time I try to enter a new entry on the list it starts to over write
> my
> existing enteries. Does anyone know if there is a maximum number of
> characters allowed per drop down!? Or does anyone know how to get around
> this
> problem!?
>
> Thanks,
>
> C

I wonder if its because you're typing items directly into the DV's source box?

You could try the other options (eg: named/defined range) in Debra's page:
http://www.contextures.com/xlDataVal01.html
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Davieslondon" wrote:
> I am having difficulty in adding new enteries to my data validation list,
> every time I try to enter a new entry on the list it starts to over write my
> existing enteries. Does anyone know if there is a maximum number of
> characters allowed per drop down!? Or does anyone know how to get around this
> problem!?

Thanks very much.

C

"Bob Phillips" wrote:

> Put the values in a range, and point the DV at that range rather then embed
> them.
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Davieslondon" <(E-Mail Removed)> wrote in message
> news:419F83B8-F99B-457C-B386-(E-Mail Removed)...
> > Hi,
> >
> > I am having difficulty in adding new enteries to my data validation list,
> > every time I try to enter a new entry on the list it starts to over write
> > my
> > existing enteries. Does anyone know if there is a maximum number of
> > characters allowed per drop down!? Or does anyone know how to get around
> > this
> > problem!?
> >
> > Thanks,
> >
> > C
>
>
>

I think it was, but have now resloved the issue.

Thank you.

"Max" wrote:

> I wonder if its because you're typing items directly into the DV's source box?
>
> You could try the other options (eg: named/defined range) in Debra's page:
> http://www.contextures.com/xlDataVal01.html
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> Downloads:20,500 Files:365 Subscribers:65
> xdemechanik
> ---
> "Davieslondon" wrote:
> > I am having difficulty in adding new enteries to my data validation list,
> > every time I try to enter a new entry on the list it starts to over write my
> > existing enteries. Does anyone know if there is a maximum number of
> > characters allowed per drop down!? Or does anyone know how to get around this
> > problem!?
>