Hello,
I am trying to create programmatically a validation list that contains comma
values and I cant 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