excel ¥i¥H¥Î®Ö¨ú¤è¶ô¡A¨Ó¿z¿ï¶Ü¡H
- ©«¤l
- 93
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 134
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS7
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-3-21
- ³Ì«áµn¿ý
- 2020-11-30
|
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
ActiveSheet.Range("$A$2:$B$7").AutoFilter Field:=1, Criteria1:="<>"
Else
ActiveSheet.Range("$A$2:$B$7").AutoFilter Field:=1
End If
End Sub |
|
|
|
|
|
|
- ©«¤l
- 93
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 134
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS7
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-3-21
- ³Ì«áµn¿ý
- 2020-11-30
|
|
|
|
|
|
|