[Visual Basic] 纯文本查看 复制代码 Private Sub CommandButton1_Click()
If TextBox1.value = "" Then
MsgBox "预测数据不能为空,请输入正确的预测数据!"
Exit Sub
End If
Dim numbers As Variant
Dim i As Long
Dim targetSheet As Worksheet
Dim targetRange As Range
'华丽分割线之间,这个完整的。你可以一用。下午的配合你的多少有点问题,现在目测没问题
'华丽分割线---------------------------------------------
Dim reg, m, ms
Dim row%
Set reg = CreateObject("vbscript.regexp")
With reg
sr = TextBox1.Text
.Pattern = "^(?:(?:[1-2][0-9]?|3[0-3]?) ){6}(?:[1-2][0-9]?|3[0-3]?)$"
.Global = True
.MultiLine = True
If .test(sr) Then
Set ms = .Execute(sr)
For Each m In ms
row = row + 1
If row <= 30 Then
arr = VBA.Split(m.value, " ")
Sheets("Sheet1").Range("a" & row).Resize(1, 7) = arr
Else
Exit For
End If
Next
MsgBox "数据录入完成!"
TextBox1.value = ""
Else
End
End If
End With
'华丽分割线---------------------------------------------
' numbers = Split(TextBox1.Text, " ")
'
' Set targetSheet = ThisWorkbook.Sheets("Sheet1")
'
' Set targetRange = targetSheet.Range("A1")
'
' For i = LBound(numbers) To UBound(numbers) Step 7
'
' targetRange.Resize(1, 7).value = Array(numbers(i), numbers(i + 1), numbers(i + 2), numbers(i + 3), numbers(i + 4), numbers(i + 5), numbers(i + 6))
' Set targetRange = targetRange.Offset(1, 0)
' Next i
'
' MsgBox "数据录入完成!"
' TextBox1.value = ""
End Sub |