Hi,

I have data validation set up on a cell which has my validation
criteria set to be a List. Everything is working fine for me except
when the data (coming from a database) I am creating the list from has
a comma, the list then treats it as a new entry even though its not.

Is there a different delimiter you can use in a validation list apart
from a comma? Are you able to specify it via code?

Cheers,

Rick

I may be wrong, but I believe that the delimiter used by data validation
comes from Windows' Regional Settings and cannot be customized.

--

Vasant


"Rick De Marco" wrote in message
om...
Hi,

I have data validation set up on a cell which has my validation
criteria set to be a List. Everything is working fine for me except
when the data (coming from a database) I am creating the list from has
a comma, the list then treats it as a new entry even though its not.

Is there a different delimiter you can use in a validation list apart
from a comma? Are you able to specify it via code?

Cheers,

Rick

If you import the data onto a worksheet, you can refer to that range as
the list source. When a cell in the range contains a comma, the entire
cell will be treated as one item in the list.

Rick De Marco wrote:
I have data validation set up on a cell which has my validation
criteria set to be a List. Everything is working fine for me except
when the data (coming from a database) I am creating the list from has
a comma, the list then treats it as a new entry even though its not.

Is there a different delimiter you can use in a validation list apart
from a comma? Are you able to specify it via code?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html