- ©«¤l
- 2
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 3
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-4-12
- ³Ì«áµn¿ý
- 2013-4-15
|
¦U¦ì«e½ú¦n¡A§Ú³Ìªñ¹J¨ì«È¤H¸ò§Ú´£¡A§Æ±æEXCELÀx¦s®æ¥un¬OªÅ¥Õªº¦a¤è¤~¯à¿é¤J¡A¥B¥u¯à¿é¤J¤@¦¸¡A¦sÀÉ«á´N¤£¯àק諸»Ý¨D¡A
¤Wºô½§äµL·N¤¤µo²{VBA¥i¥H¹F¨ì³oӻݨD¡A¨Ã§ä¨ì¤F³o¬q½X
Dim mm, nn
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If nn > 1 Then
Selection = mm
Application.EnableEvents = True
Exit Sub
End If
If mm <> "" Then Target = mm
Application.EnableEvents = True
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
nn = Target.Count
mm = Target
End Sub
¸g´ú¸Õ«á½T¹ê¥i¥H¹F¨ì«È¤H©Ò»Ýªº¨î¡A¦ý¬Oµo¥Í¤F¤@Ó°ÝÃD¡A
´N¬OYÀx¦s®æ¦¡³æ®æªº¸Ü¡A¨S°ÝÃD¡C
YÀx¦s®æ¬O¦X¨ÖÀx¦s®æ¡A´N¨S¦³®Ä¥Î¡A©Ò¥H·Q½Ð±Ðª©¤Wªº«e½ú¬O§_¥i¥H¨ó§U¬Ý¤@¤Un¦p¦óקï³oµ{¦¡½X¡A
·P¿E¤£ºÉ¡C
Microsoft Excel ¤u§@ªí.rar (13.51 KB)
|
|