Hi,

I'm working in an application that generates an excel file with a data
validation list. The problem its because my values im putting in that list
also contains comma characters, but i dont want to split up this value.
Someone knows if there is a special character i can put at the string to
appears as a comma when using the dropdown?

Thanks
Christiano

Be more specific; include a snippet of your code if possible. It may be that
you simply need to enclose the portion of the string containing the commas
within quote marks.

"Christiano Borchardt" wrote:

Hi,

I'm working in an application that generates an excel file with a data
validation list. The problem its because my values im putting in that list
also contains comma characters, but i dont want to split up this value.
Someone knows if there is a special character i can put at the string to
appears as a comma when using the dropdown?

Thanks
Christiano

Put your list in a range (on a hidden worksheet???) and name that range. Then
use that name in your Data|validation list box.



Christiano Borchardt wrote:

Hi,

I'm working in an application that generates an excel file with a data
validation list. The problem its because my values im putting in that list
also contains comma characters, but i dont want to split up this value.
Someone knows if there is a special character i can put at the string to
appears as a comma when using the dropdown?

Thanks
Christiano

--

Dave Peterson

Create a named range (could be in a hidden sheet)

Tim

--
Tim Williams
Palo Alto, CA


"Christiano Borchardt" wrote in message
...
Hi,

I'm working in an application that generates an excel file with a data
validation list. The problem its because my values im putting in that list
also contains comma characters, but i dont want to split up this value.
Someone knows if there is a special character i can put at the string to
appears as a comma when using the dropdown?

Thanks
Christiano