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