参考代码
Dim str As String = "A,B,C,D"Dim ss As String = "C,A,B"Dim ary = ss.split(",")Dim nstr As String = ""For Each s As String In str.split(",") If ary.Indexof(ary, s) >= 0 Then nstr &= s & "," End IfNextmsgbox(nstr.trim(","))