View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default Ignoring comma when creating validation lists

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