麻烦老师帮忙改一下代码

okok588 okok588 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
Private Sub Command15_Click()
Dim str1 As String, c As String
Dim arr() As String
Dim ii As Integer, hh As Integer, y As Integer
Dim a(1 To 12) As String
Dim count(7 To 12) As Long
Dim s As Integer
Dim i As Long, j As Long, k As Long, m As Long
Dim h As String

For ii = 0 To List2.ListIndex
str1 = List2.List(ii)
arr = Split(str1, ",")

For i = 0 To 11
a(i + 1) = arr(i)
Next
For y = 1 To MSFlexGrid1.Rows - 1
s = MSFlexGrid1.TextMatrix(y, 1)
c = s

If Len(c) = 3 And IsNumeric(c) And InStr(1, c, "-") = 0 And InStr(1, c, ".") = 0 And InStr(1, c, "E") = 0 Then
For k = 1 To 3
For j = 7 To 12
If InStr(1, a(j), Mid(c, k, 1)) <> 0 Then count(j) = count(j) + 1
Next j
Next k
For m = 7 To 12
If count(m) <> 0 Then
h = h & count(m) & a(m - 6)
End If
Next
End If


hh = MSFlexGrid1.Col

MSFlexGrid1.TextMatrix(y, hh + ii) = h

Erase count
h = ""
Next
Next

End Sub
这段代码不能辨认类似于s=078的,只要s开头是0的都不能辨认,该如何改呢
...全文
评论 3
收藏 已收藏
分享
返回顶部
okok588
VB基础类 7,788 成员 197,583 内容