7,762
社区成员
发帖
与我相关
我的任务
分享
Private Sub Command1_Click()
snow(1) = Mid(Text1.Text, 1, 2)
snow(2) = Mid(Text1.Text, 3, 3)
snow(3) = Mid(Text1.Text, 6, 3)
snow(4) = Mid(Text1.Text, 9, 3)
snow(5) = Mid(Text1.Text, 12, 3)
snow(6) = Mid(Text1.Text, 15, 3)
snow(7) = Mid(Text1.Text, 18, 3)
snow(8) = Mid(Text1.Text, 21, 3)
bijiao(1) = Mid(Text2.Text, 1, 2)
bijiao(2) = Mid(Text2.Text, 3, 3)
bijiao(3) = Mid(Text2.Text, 6, 3)
bijiao(4) = Mid(Text2.Text, 9, 3)
b = 0
For a = 1 To 8
If snow(a) = bijiao(1) Then
GoTo Line1
ElseIf snow(a) = bijiao(2) Then
GoTo Line1
ElseIf snow(a) = bijiao(3) Then
GoTo Line1
ElseIf snow(a) = bijiao(4) Then
GoTo Line1
Else
goto line2 End If
Line1:
b = b + 1
If b = 1 Then
nexta1.text = snow(a - 1)
nextb1.text = snow(a)
nwxtc1.text = snow(a + 1)
ElseIf b = 2 Then
nexta2.text = snow(a - 1)
nextb2.text = snow(a)
nwxtc2.text = snow(a + 1)
ElseIf b = 3 Then
nexta3.text = snow(a - 1)
nextb3.text = snow(a)
nwxtc3.text = snow(a + 1)
ElseIf b = 4 Then
nexta4.text = snow(a - 1)
nextb4.text = snow(a)
nwxtc4.text = snow(a + 1)
End If
line2:
Next a
End Sub
'看一下我的代码是否是你要的功能.
Dim Snow(1 To 8) As Long
Dim BiJiao(1 To 4) As Long
Private Sub CommandButton1_Click()
Dim i As Long
Dim j As Long
Dim b As Long
Snow(1) = CLng(Mid(Text1.Text, 1, 2))
For i = 2 To 8
Snow(i) = CLng(Mid(Text1.Text, i * 3 - 3, 3))
Next
BiJiao(1) = CLng(Mid(Text2.Text, 1, 2))
For i = 2 To 4
BiJiao(i) = CLng(Mid(Text2.Text, i * 3 - 3, 3))
Next
For i = 1 To 8
For j = 1 To 4
If Snow(i) = Snow(j) Then
b = b + 1
Select Case b
Case 1
If i > 1 Then nexta1.Text = Snow(i - 1)
nextb1.Text = Snow(i)
If i < 8 Then nwxtc1.Text = Snow(i + 1)
Case 2
If i > 1 Then nexta2.Text = Snow(i - 1)
nextb2.Text = Snow(i)
If i < 8 Then nwxtc2.Text = Snow(i + 1)
Case 3
If i > 1 Then nexta3.Text = Snow(i - 1)
nextb3.Text = Snow(i)
If i < 8 Then nwxtc3.Text = Snow(i + 1)
Case 4
If i > 1 Then nexta4.Text = Snow(i - 1)
nextb4.Text = Snow(i)
If i < 8 Then nwxtc4.Text = Snow(i + 1)
End Select
End If
Next
Next
End Sub