7,763
社区成员
发帖
与我相关
我的任务
分享
'以下示例要满足以下条件.每行数据只能有一个字符
'数据必须是0-9之间的数据.
Option Explicit
Dim i As Long
Dim j As Long
Private Sub Command1_Click()
Dim Data As String
Data = ""
For i = ListView1.ListItems.Count To 1 Step -1
If InStr(1, Data, ListView1.ListItems(i)) < 1 Then
Data = Data & ListView1.ListItems(i)
If Len(Data) = 9 Then
For j = 0 To 9
If InStr(1, Data, CStr(j)) = 0 Then
MsgBox "遗漏的数据是" & j
Exit Sub
End If
Next
End If
End If
Next
End Sub
Private Sub Form_Load()
ListView1.View = lvwReport
Dim Arr() As Variant
Arr = Array(5, 6, 8, 7, 2, 1, 9, 3, 5, 4, 8, 4, 1, 4, 8, 6)
ListView1.ColumnHeaders.Add , , "A列"
For i = 0 To UBound(Arr)
ListView1.ListItems.Add , , Arr(i)
Next
End Sub