|
发表于 2013-6-18 10:16
|
显示全部楼层
本楼为最佳答案
- Private Sub CommandButton1_Click()
- Dim arr, i As Long, Ar()
- Dim iRcd As Long
- Dim lLastRow As Long
- arr = Sheet3.Range("a1").CurrentRegion.Value
- ReDim Ar(1 To UBound(arr), 1 To 7)
- For i = 2 To UBound(arr)
- If arr(i, 1) = ComboBox1.Value And arr(i, 2) = ComboBox2.Value And CStr(arr(i, 3)) = ComboBox3.Value Then '增加ComboBox3.Value条件
- iRcd = iRcd + 1
- Ar(iRcd, 1) = arr(i, 4)
- Ar(iRcd, 2) = arr(i, 5)
- Ar(iRcd, 3) = arr(i, 6)
- Ar(iRcd, 4) = arr(i, 7)
- Ar(iRcd, 5) = arr(i, 8)
- Ar(iRcd, 6) = arr(i, 11)
- Ar(iRcd, 7) = arr(i, 10) & arr(i, 12)
- End If
- Next i
- With Sheet1
- .[a1].Value = "竞赛报表"
- .[b2].Value = ComboBox1.Value
- .[d2].Value = ComboBox2.Value
- .[f2].Value = ComboBox3.Value
- lLastRow = .Cells(Rows.Count, 1).End(xlUp).Row
- If lLastRow > 3 Then .Range("a4:g" & lLastRow).ClearContents
- If iRcd > 0 Then
- Sheet1.Range("a4").Resize(iRcd, 7).Value = Ar
- MsgBox "完成"
- Else
- MsgBox "无符合条件的数据"
- End If
- End With
- End Sub
复制代码 |
|