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

[µo°Ý] EXCEL Àx¦s®æ«Ø¥ß¤Î°O¿ý­×§ïªº¤é´Á

[µo°Ý] EXCEL Àx¦s®æ«Ø¥ß¤Î°O¿ý­×§ïªº¤é´Á

½Ð°Ý¥i¥H³o¼ËÀ³¥Î¶Ü?

¦^´_ 1# cubela
¸Õ¸Õ¬Ý¡A¦b¤u§@ªí¼Ò²Õ¿é¤Jµ{¦¡½X
  1. Public Temp
  2. Private Sub Worksheet_Change(ByVal Target As Range)
  3. If Target.Row <> 1 And Not Intersect(Target, Columns("A:B")) Is Nothing Then
  4. If Temp <> "" Then
  5.   Cells(Target.Row, 4) = Date
  6.   Else
  7.   Cells(Target.Row, 3) = Date
  8. End If
  9. End If
  10. End Sub

  11. Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  12. Temp = Target
  13. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  cubela
¸Õ¸Õ¬Ý¡A¦b¤u§@ªí¼Ò²Õ¿é¤Jµ{¦¡½X
Hsieh µoªí©ó 2014-12-5 19:41



    ª©¤j±z¦n:
¥i¥H­C!!·PÁ±z!!
¨º¦A½Ð±Ð¤@¤U¡A¯S©w°Ï°ìªº¸Ü¡A­n¦p¦ó¨Ï¥Î©O?

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD