|

楼主 |
发表于 2022-2-19 16:15
|
显示全部楼层
Private Sub Command1_Click()
'排序程序
Dim a, B, q
Dim t As Double
t = Timer
a = Trim(Text3)
s = 1
Do While s <= Len(a)
a1 = Mid(a, s, 1)
If Left(a1, 1) = " " Then
a1 = ""
Else
a1 = a1
End If
s103 = s103 & a1
s = s + 1
Loop
s103 = "/" & s103
s103 = Mid(s103, 1)
Dim i As Integer
Dim ak(), s105, cr(), f
Set f = CreateObject("Scripting.Dictionary")
s105 = Split(s103, "/")
j1 = UBound(s105)
Print j1
For k = 1 To j1
n1 = n1 + 1
ReDim Preserve ak(1 To n1)
ak(n1) = s105(n1)
Next
n = 0
For k = 1 To j1
n = n + 1
ReDim Preserve cr(1 To n)
m = Val(ak(k))
f(m) = ""
Print ak(k)
Next
n = 0
m = f.Keys
For i = 0 To f.Count - 1
ReDim Preserve cr(1 To i + 1)
cr(i + 1) = m(i)
Next
For i = 1 To UBound(cr) - 1
For J = i + 1 To UBound(cr)
If cr(i) > cr(J) Then
temp = cr(J)
cr(J) = cr(i)
cr(i) = temp 'c数组是排序好的
End If
Next J
' If i Mod 20 = 0 Then
' s104 = s104 & temp & "/" & vbCrLf
' Else
' s104 = s104 & temp & "/"
' End If
Next i
For i = 1 To UBound(cr)
If i Mod 20 = 0 Then
s104 = s104 & cr(i) & "/" & vbCrLf
Else
s104 = s104 & cr(i) & "/"
End If
Next
Print temp
MsgBox "ok"
MsgBox s104 '显示数组
s106 = Split(s104, "/")
j2 = UBound(s106)
Text4 = s104
End Sub |
|