VBA validation list delimited separator

korenje

New Member
Joined
Oct 10, 2018
Messages
2
Can someone explain why adding hyperlinks before adding validation switches from "," to ";" which is default xlListSeparator?

Code:
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.
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,095,479
Messages
5,444,718
Members
405,298
Latest member
fxtrtr17

This Week's Hot Topics

Top