|
楼主 |
发表于 2011-12-16 11:43
|
显示全部楼层
- Private Sub ComboBox1_Change()
- Select Case ComboBox1.Value
- Case "全部"
- 'Range("A1:B20").AutoFilter Field:=2
- Case "男生"
- Dim X, Y As Range, i%
- Cells.EntireRow.Hidden = False
- X = Range([a1], [b65536].End(3))
- For i = 1 To UBound(X)
- If X(i, 2) = "女生" Then
- If Y Is Nothing Then Set Y = Cells(i, 1) Else Set Y = Union(Y, Cells(i, 1))
- End If
- Next
- If Not Y Is Nothing Then Y.EntireRow.Hidden = True
-
- Case "女生"
- Dim aa, bb As Range, j%
- Cells.EntireRow.Hidden = False
- aa = Range([a1], [b65536].End(3))
- For j = 1 To UBound(aa)
- If aa(j, 2) = "男生" Then
- If bb Is Nothing Then Set bb = Cells(j, 1) Else Set bb = Union(bb, Cells(j, 1))
- End If
- Next
- If Not bb Is Nothing Then bb.EntireRow.Hidden = True
- End Select
- End Sub
复制代码 |
|