--
bprajap

First of all, you should give more details for us to answer.
Based on the little explanation you have provided, I think you can list all
your items in excel and add comma at the end of each item. Then use this
range as input range for your Data Validation.

Thanks.
HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think a post is useful, please rate it as an ANSWER, it will help
others!!


"bhavna" wrote:


--
bprajap

Sorry about not being clear.
What I mean that I want to have data validation for a column with a list.
And as you know that list items needs to seperated with comma. My question is
that how can use a list item with comma. e.g. #,0, #.0 etc. In my case I want
my list to look like
#,0
#.0

Thanks
--
bprajap


"Pranav Vaidya" wrote:

First of all, you should give more details for us to answer.
Based on the little explanation you have provided, I think you can list all
your items in excel and add comma at the end of each item. Then use this
range as input range for your Data Validation.

Thanks.
HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think a post is useful, please rate it as an ANSWER, it will help
others!!


"bhavna" wrote:


--
bprajap

Enter your list in a range of cells.

When selecting source for list use that range rather than a comma-delimited
list.


Gord Dibben MS Excel MVP

On Fri, 5 Sep 2008 13:37:08 -0700, bhavna
wrote:

Sorry about not being clear.
What I mean that I want to have data validation for a column with a list.
And as you know that list items needs to seperated with comma. My question is
that how can use a list item with comma. e.g. #,0, #.0 etc. In my case I want
my list to look like
#,0
#.0

Thanks

Thanks Gord for the reply, I will try this. It looks like a good solutions.
--
bprajap


"Gord Dibben" wrote:

Enter your list in a range of cells.

When selecting source for list use that range rather than a comma-delimited
list.


Gord Dibben MS Excel MVP

On Fri, 5 Sep 2008 13:37:08 -0700, bhavna
wrote:

Sorry about not being clear.
What I mean that I want to have data validation for a column with a list.
And as you know that list items needs to seperated with comma. My question is
that how can use a list item with comma. e.g. #,0, #.0 etc. In my case I want
my list to look like
#,0
#.0

Thanks

Hi Gord

I tried to use the range but doesn't work in my case.
I am getting the list of values from the database and I am storing that in a
comma delimited string. I tried if can copy that string into range but it
doesn't work. If you or anyone has suggestions then please help me.

Thanks
--
bprajap


"bhavna" wrote:

Thanks Gord for the reply, I will try this. It looks like a good solutions.
--
bprajap


"Gord Dibben" wrote:

Enter your list in a range of cells.

When selecting source for list use that range rather than a comma-delimited
list.


Gord Dibben MS Excel MVP

On Fri, 5 Sep 2008 13:37:08 -0700, bhavna
wrote:

Sorry about not being clear.
What I mean that I want to have data validation for a column with a list.
And as you know that list items needs to seperated with comma. My question is
that how can use a list item with comma. e.g. #,0, #.0 etc. In my case I want
my list to look like
#,0
#.0

Thanks