Thank your for your reply.
I can't use another separator because this value will be used in another
formula :-/

And as far as I know and just tested, you can't assign a range to the
validate property that is on another sheet :-(

"Dave Peterson" wrote:

I think you were hit by VBA being USA centric.

If I enter 1,0;1,2 directly in the data|validation dialog (with comma my list
separator), I get what you get from your code.

Can you put the values in a range on a hidden worksheet and use them from there?

Can you use a different character than comma?
1-0,1-2,1-3...

Maybe use another cell to change the dash back to comma if you really need it:
=substitute(a1,"-",",")

Sebastian wrote:

Hello,
I am trying to create programmatically a validation list that contains comma
values and I can€„¢t get it to work.

In Excels validation dialog I can manually enter the formula in the filed
which works fine (; separated list for example: 1,0;1,2 ...)

I if enter this via VBA as Formula1 "1,0;1,2" things get messed up:
1. Value: 1
2. Value: 0;1
3. Value: 2

The Problem is that the values are calculated at runtime so I can't enter
them in the dialog and the list is needed because the user will only known
the approximate and not the exact values which can be entered and they will
have some more decimal places.
Last but not least an analyzing software which runs over the sheet doesn't
allow that there are any hidden columns or values so I can't just make an
reference to a range which contains the values...

Now the question is, if is this possible to do or has Microsoft totally
messed up the validation.add function??

Any help is appreciated!

Kind regards,
Sebastian

--

Dave Peterson