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

[µo°Ý] ½Ð°Ý¦p¦ó¥ÎEXCEL¦Û°ÊÀx¦s¨C¤ÀÄÁ¸ê®Æ¨ì«ü©wÀx¦s®æ¤¤©O

[µo°Ý] ½Ð°Ý¦p¦ó¥ÎEXCEL¦Û°ÊÀx¦s¨C¤ÀÄÁ¸ê®Æ¨ì«ü©wÀx¦s®æ¤¤©O

±z¦n¡G

½Ð°Ý¤p©f¦³­ÓexcelÀÉ®×·í¤¤¤w¸g¦³DDE³sµ²¡A¦Ó¨ä¤¤¦³­Ó­È¬O·|¨C¤ÀÄÁÅܰʤ@¦¸ªº¡A
·Q½Ð°Ý¤j¤j¦p¦óÅý³o­Ó¨C¤ÀÄÁÅܰʪº­È¦Û°ÊÀx¦s¦b½d¨Ò¤¤ªºA5:A34Àx¦s®æ¤¤©O??

¦b³Â»¶®a±Ú¤¤ª¦¤F¦n´X½g¤å³¹¡A¥i¬O§â¤å³¹¤¤ªºµ{¦¡½X¶K¨Ó¶K¥h...¤p©fªºÀÉ®×ÁÙ¬O¤@ª½¸õ¥X°»¿ùµøµ¡...
¯uªº¬O«Ü¦Ç¤ß~~
ÁÙ¦³³Ò¦U¦ì¤j¤jÀ°À°¤p©f¤F

Auto.zip (4.84 KB)

·PÁ¦U¦ì¤j¤jªº¦^ÂлPÀ°§U¡A¤×¨ä¯S§O·PÁÂHsiehªº¼ö¤ßÀ°¦£~~~¯uªº«ÜÁÂÁ±z~~
¦]¬°µ¥¯Å¤£°÷¡A©Ò¥H¬Ý§O½g¤å³¹ªºµ{¦¡½X«o¨Sªk¤U¸üÀɮפU¨Ó¾Ç²ß¡A¤p©f¯uªº¬O¬Ý±oÃú¨F¨F~
¤£¹L§Ú·|Ä~Äò§V¤O~§Æ±æ¤]¦³¾÷·|¯à¼ö¤ßÀ°§U¦³»Ý­nªºªB¤Í~~~§V¤O§V¤O~~

¯uªº«ÜÁÂÁ¤j®a~~~³o¸Ì¯u¬O¦n¦a¤èªü~~~

TOP

¦^´_ 4# jojomo

§â§Aªº®É¶¡¨ç¼Æ®³±¼¡AÁקK°ïÅ|ªÅ¶¡¤£¨¬
  1. Private Sub Worksheet_Calculate()
  2. [A65536].End(xlUp).Offset(1, 0).Resize(, 4) = Array(Format(Now, "hh:mm"), [A2].Value, [B2].Value, [C2].Value)
  3. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

TOP

¦^´_ 1# jojomo
½Ð°Ñ¦Ò    http://gb.twbts.com/index.php?topic=11429.0

TOP

©p¶K¤F¤°»òµ{¦¡½X¶K¥X¨Ó¬Ý¬Ý¦n¶Ü¡H
¤@§Z¤T¥|¡BÅå¨ìåF¥N»x

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD