¥i¥H§Q¥ÎVBA¶i¦æ¦h±ø¥ó¿z¿ï¶Ü?
- ©«¤l
- 103
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 139
- ÂI¦W
- 0
- §@·~¨t²Î
- wondows XP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¹ü¤Æ
- µù¥U®É¶¡
- 2013-2-21
- ³Ì«áµn¿ý
- 2015-6-26
|
¥i¥H§Q¥ÎVBA¶i¦æ¦h±ø¥ó¿z¿ï¶Ü?
|
Jared
|
|
|
|
|
- ©«¤l
- 103
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 139
- ÂI¦W
- 0
- §@·~¨t²Î
- wondows XP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¹ü¤Æ
- µù¥U®É¶¡
- 2013-2-21
- ³Ì«áµn¿ý
- 2015-6-26
|
¦^´_ 1# Jared
µo²{§Q¥Î³°»s¥¨¶°ªº¤è¦¡
¥i¥H¤@¦¸¿z¿ï¤@Ó±ø¥ó
¨º¦pªG¬On¨âÓ¥H¤W
n«ç»ò³]©w©O?- Private Sub CommandButton4_Click() '¿z¿ï±ø¥ó
- Dim a, b, c, d, e
- a = Test5.TextBox1.Text
- b = Test5.ComboBox1.Value
- c = Test5.ComboBox2.Value
- d = Test5.ComboBox3.Value
- e = Test5.TextBox2.Text
- If a <> "" Then
- ActiveSheet.Range("$A$1:$E$12").AutoFilter Field:=1, Criteria1:=a: Exit Sub
- End If
- If b <> "" Then
- ActiveSheet.Range("$A$1:$E$12").AutoFilter Field:=2, Criteria1:=b: Exit Sub
- End If
- If c <> "" Then
- ActiveSheet.Range("$A$1:$E$12").AutoFilter Field:=3, Criteria1:=c: Exit Sub
- End If
- If d <> "" Then
- ActiveSheet.Range("$A$1:$E$12").AutoFilter Field:=4, Criteria1:=d: Exit Sub
- End If
- If e <> "" Then
- ActiveSheet.Range("$A$1:$E$12").AutoFilter Field:=5, Criteria1:=e: Exit Sub
- End If
- End Sub
½Æ»s¥N½X |
|
Jared
|
|
|
|
|
- ©«¤l
- 103
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 139
- ÂI¦W
- 0
- §@·~¨t²Î
- wondows XP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¹ü¤Æ
- µù¥U®É¶¡
- 2013-2-21
- ³Ì«áµn¿ý
- 2015-6-26
|
¦^´_ 3# GBKEE
·PÁ¤j¤j¸Ñ°£¤F§ÚªººÃ´b
쥻ªºµ{¦¡½X¬O¼g¦¨¿W¥ß¦¡- If a <> "" Then
- ActiveSheet.Range("$A$1:$E$12").AutoFilter Field:=1, Criteria1:=a: Exit Sub
- End If
½Æ»s¥N½X «á¨Ó¦³×§ï¦¨- Private Sub CommandButton4_Click()
- Dim a, b, c, d, e
- a = Test5.TextBox1.Text
- b = Test5.ComboBox1.Value
- c = Test5.ComboBox2.Value
- d = Test5.ComboBox3.Value
- e = Test5.TextBox2.Text
- If a <> "" Or b <> "" Or c <> "" Or d <> "" Or e <> "" Then
- With Sheet2.Range("$A$1:$E$12")
- .AutoFilter Field:=1, Criteria1:=a
- .AutoFilter Field:=2, Criteria1:=b
- .AutoFilter Field:=3, Criteria1:=c
- .AutoFilter Field:=4, Criteria1:=d
- .AutoFilter Field:=5, Criteria1:=e
- End With
- End If
- End Sub
½Æ»s¥N½X ¦ý«oÅܦ¨n¨CÓ±ø¥ó³£²Å¦X¤~·|¿z¿ï¥XªF¦è>"<
¬Ý¤F¤j¤jªº¸Ñµª
ì¨Ó¬On¤À¶}¶i¦æ
¬Ý¨Ó§Ú¤S¾Ç¨ì¤@½Ò¤F^¤f^
«D±`·PÁ¡I¡I |
|
Jared
|
|
|
|
|
- ©«¤l
- 103
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 139
- ÂI¦W
- 0
- §@·~¨t²Î
- wondows XP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¹ü¤Æ
- µù¥U®É¶¡
- 2013-2-21
- ³Ì«áµn¿ý
- 2015-6-26
|
¦^´_ 5# jeffrey628litw
§A¥i¥H§â¼Ó³»°ÝÃDªº´ú¸ÕÀɤU¸ü¤U¨Ó
¦b§âµ{¦¡½X´À´«±¼´N¥i¥H¤F
¤¶±¤WÀ³¸Ó¬O¨S¤°»ò§ï¨ì
¥u¦³¦bµ{¦¡½Xªº³¡¤À |
|
Jared
|
|
|
|
|