- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 13
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-10-25
|
¥»©«³Ì«á¥Ñ luhpro ©ó 2016-4-16 01:25 ½s¿è
¦^´_ 4# ã´£³¡ªL
¶â...
¥^¦£¤U·í®É§Ú¥u°O±o½ DblClick ¨Æ¥ó¿ï³æ¨S©¹¤W©Ô...
¬O§Úªº²¨©¿,©êºp.
¦^´_ 1# vinejason
²{¦b¬Ý¨ì Worksheet ªGµM¬O¦³ BeforeDoubleClick ¨Æ¥ó.
¨º»òn°µ¨ì¼Ó¥Dªº»Ý¨D´N®e©ö¤F.- Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
- With Target
- If .Parent.FilterMode Then ' Àˬd¦Û°Ê¿z¿ïª¬ºA
- Selection.AutoFilter ' ¬O«h¨ú®ø¦Û°Ê¿z¿ïª¬ºA
- Else
- Selection.AutoFilter Field:=.Column, Criteria1:=.Value, VisibleDropDown:=False ' Field : ¿z¿ïÈÄæ¦ì¸¹½X, Criteria1 : ¿z¿ïÈ, VisibleDropDown : ¦Û°Ê¿z¿ïª¬ºA®Én¤£nÅã¥Ü¦V¤U½bÀY
- End If
- End With
- Cancel = True ' ¤§«á¤£n°õ¦æ¨Ï¥ÎªÌ«ö¤U Double Click ªº³B²z°Ê§@
- End Sub
½Æ»s¥N½X
DblClick«á¦Û°Ê¿z¿ï.zip (9.28 KB)
¥t¤@Ó¤U¸üºô§} :
http://www.FunP.Net/592865 |
-
1
µû¤À¤H¼Æ
-
|