Option Explicit 'dongge2000原创 Private Sub Command1_Click() Dim Arr() As String Dim i As Long Dim Str As String Dim MyArr() As String Str = Text1.Text Str = Replace(Str, "+", "_") Str = Replace(Str, "-", "_") Str = Replace(Str, "*", "_") Str = Replace(Str, "/", "_") Str = Replace(Str, "\", "_") Str = Replace(Str, "^", "_") Str = Replace(Str, "(", "_") Str = Replace(Str, ")", "_") Str = Replace(Str, "[", "_") Str = Replace(Str, "]", "_") Debug.Print Str Arr = Split(Str, "_")For i = LBound(Arr) To UBound(Arr) If Len(Arr(i)) > 0 Then If CLng(Arr(i)) >= 0 Then ReDim Preserve MyArr(1, i) As String MyArr(1, i) = Arr(i) End If If CLng(Arr(i)) < 0 Then ReDim Preserve MyArr(-i, -1) As String MyArr(i, -1) = Arr(i) End If End If NextEnd Sub==================== 以前csdn上的问题,自己看看合适不?
'dongge2000原创
Private Sub Command1_Click()
Dim Arr() As String
Dim i As Long
Dim Str As String
Dim MyArr() As String
Str = Text1.Text
Str = Replace(Str, "+", "_")
Str = Replace(Str, "-", "_")
Str = Replace(Str, "*", "_")
Str = Replace(Str, "/", "_")
Str = Replace(Str, "\", "_")
Str = Replace(Str, "^", "_")
Str = Replace(Str, "(", "_")
Str = Replace(Str, ")", "_")
Str = Replace(Str, "[", "_")
Str = Replace(Str, "]", "_")
Debug.Print Str
Arr = Split(Str, "_")For i = LBound(Arr) To UBound(Arr)
If Len(Arr(i)) > 0 Then
If CLng(Arr(i)) >= 0 Then
ReDim Preserve MyArr(1, i) As String
MyArr(1, i) = Arr(i)
End If
If CLng(Arr(i)) < 0 Then
ReDim Preserve MyArr(-i, -1) As String
MyArr(i, -1) = Arr(i)
End If
End If
NextEnd Sub====================
以前csdn上的问题,自己看看合适不?