VBA validation list delimited separator

[korenje]

Can someone explain why adding hyperlinks before adding validation switches from "," to ";" which is default xlListSeparator?

Sub test2()    a = Join(Application.Transpose(Selection.Columns(1).Value2), "; ")
    Selection.ClearHyperlinks
    Selection.Validation.Delete
    Selection.Hyperlinks.Add Anchor:=Selection.Columns(3), Address:="no address"
    Selection.Columns(2).Validation.Add Type:=xlValidateList, Formula1:=a
End Sub

If I select range with 3 columns this will add dropdown list to column 2. However the list will be separated by ";" if hyperlinks are added before validation and if hyperlinks are added after validation the list will be separated by ",".

";" is default list separator for my language settings tho.