ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¬°¦óvba¤£¯à¤u°µ©O?

¬°¦óvba¤£¯à¤u°µ©O?

Public Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
Target.Offset(, -1) = Now
End If
End Sub
¬O¨º¸Ì¦³°ÝÃD,½Ð¤j¤j¸Ñµª Book1.zip (6.72 KB)

¥»©«³Ì«á¥Ñ jackdream ©ó 2010-7-2 15:20 ½s¿è

¬O­n§ó´« sheet ®É,±Ò°Êµ{§Ç¶Ü?
==> ³o­Ó©ñ¦b ThisWorkbook ,¥Î Private Sub Workbook_SheetActivate(ByVal Sh As Object)

©ÎªÌ¬O­n§ó§ïÀx¦s®æ¤º®e®É±Ò°Êµ{§Ç?
==> ³o­Ó©ñ¦b sheet ¸Ì­±,¥Î Private Sub Worksheet_Change(ByVal Target As Range)

TOP

½Ð°Ý­n¦p¦ó©ñ¨ìSHEET¸Ì­±,§Ú¬O·s¤H¤£ª¾¦p¦ó³B²z.

TOP

½Ð°Ý­n¦p¦ó©ñ¨ìSHEET¸Ì­±


±z¦n! ½Ð°Ñ¦Òªþ¹Ï.
sample.jpg
2010-7-2 15:22

TOP

Jack ÁÂÁÂ,¤w¸g¥i¥H¤F,­ì¨Ó¬O©ñ¿ù¦a¤è¤~¤£¯à°õ¦æ.

TOP

·s¤B°Ýªº²Â°ÝÃD½Ðª¾¹DªºÀ°¦£¤@¤U.
½Ð°Ý§Ú¦b¥t¤@­Ó¤u§@ªí¤¤¤]©ñ¤F¦P¼Ëªºvba¤º®e¦³µy¦³¤@ÂI¤£¦P,«o¤£¯à°õ¦æ.¨º¤S¬O¬°¤°»ò?

TOP

©êºp,­è¼g¦n®É¤£¯à°õ¦æ.¦ý¦sÀɦA­«¶},´N¥i¥H¤F.»Ý±æ¤£­n»~¾É¤j®a.
¤]¤£ª¾¹D¬O¬°¤°»ò?

TOP

©êºp,­è¼g¦n®É¤£¯à°õ¦æ.¦ý¦sÀɦA­«¶},´N¥i¥H¤F.»Ý±æ¤£­n»~¾É¤j®a.
¤]¤£ª¾¹D¬O¬°¤°»ò?
ANGELA µoªí©ó 2010-7-14 13:13


¥i¯à¬Ovba project¥¼¤Î¦Û°Ê­«·s¾ã²z¦n
¤U¦¸¶K¤W¥N½X«á¥i¥H«ö¤@¤U "°»¿ù->½sĶvbaproject"

    http://kimbalko-chi.blogspot.com ... xcel-1997-2010.html
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

­ì¨Ó¦p¦¹,ÁÂÁ«ü¾É.¥t½Ð°ÝÃþ¦ü³oºØªºVBA¤£¯à¥ÎF8¨Ó´ú¸Õ,¨º­n¦p¦óª¾¹D¨º¸Ì¦³¿ù?

TOP

¦^´_ 9# ANGELA


    ¥ý³]©w¤¤Â_ÂI(¦bµ{¦¡¥ô·N³B«öF9)
²£¥Í½Å¦â¤¤Â_ÂI«á
IJµo¨Æ¥ó«á§Y·|°õ¦æ¨ì¤¤Â_³B°±¤î
´N¥i«öF8³v¦æ°»¿ù
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD