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

·Q½Ð°Ý set ª«¥ó°ÝÃD

·Q½Ð°Ý set ª«¥ó°ÝÃD

¦U¦ì¥ý¶i±z¦n

¤µ¤Ñ¬Ý¨ì¤@­ÓªB¤ÍªºVBA µ{¦¡½s½X¸Ì­±¦³¨â¦æ

Set xRow1 = MySht.[L12176:Q12176]: Set xRow2 = MySht.[A5:F5] 'Range("A5:F5")
Set xTime = MySht.[Q12176]: Set xChk = MySht.[W9182]  


½Ð°ÝSet µ¹»Pª«¥ó³o­Ó¥\¯à     ²Ä¤@±Æ «á­± .[L12176:Q12176]: Set xRow2   ....µ¥µ¥

¬°¤°»ò¥i¥H  ¥Î¤@­Ó¡y:¡z + ¡yªÅ®æ¡z  ¦A¥[¤W  ¥t¥~¤@­ÓSet

³o¬O¤°»ò¥Îªkªü  ??

¥»©«³Ì«á¥Ñ bobomi ©ó 2019-7-17 15:15 ½s¿è

:  µ¥®Ä ´«¦æªº·N«ä ( Enter Áä )

°£¤F a=0: b=0: c=0 ³oºØ·¥Â²µu«¬

¨ä¥L¦a¤è¾¨¶q¤Ö¥Î

TOP

¦^´_ 2# bobomi


¤F¸Ñ¤F¡AÁÂÁ«e½ú«ü¾É¡C

·PÁÂ

¨ä¹êset ¤@±ø¤@¦æ¤@­Ó½á¤©ª«¥ó  ÁÙ¬O¤ñ¸û¥¿²Îªº¼gªk ÁÂÁÂ~

TOP

¦^´_ 3# handsometrowa


À½¦b¤@¦æªº¼gªk , µL«D¬O¨âºØ¥Øªº

(1) ¤£¥Îºu·Æ¹« , ¤@²´¥iÁaÄý
(2) Åýµ{¦¡½X¬Ý°_¨Ó¤ñ¸û¤Ö¦æ´N¯à¿ì¨ì , Åý¤H·Pı¤ñ¸û¼F®`ÂI

¦pªG¥Øªº¬O (2) ¨º´N§K¤F

TOP

¦b¸ÑŪµ{¦¡½X®É, ¤£§K¤W¤W¤U¤U¥h¤ñ¹ï¦UÅܼƩΪ«¥óªº³]©w,
­Y¯àÀ½¦b¦P¤@µe­±¤¤ª½±µÅª¨ú, ¦Ó§K¥h¤W¤U·Æ°Êµøµ¡, ³o¬O¤@­Ó¨ú¥©¤èªk,
¹ï­è±µÄ²vbaªÌ, ³Ì¦nÁÙ¬O¤@¦æ¤@¦æªº¼g~~

¥t¥~, ¼gvba¤]»P¼g¤å³¹Ãþ¦ü, ¨ººØ¼gªk, ¦³ÂI¹³"³r¸¹", ¦ê¦¨¤@¦æ, ¹³¬q¸¨~~
©ÎªÌ, ¬Û¦P§PÂ_±ø¥ó¤U, ±N­n±o¥Xªºµ²ªG, ¥Î³o¤èªk¦ê±µ, ¤S¦³ÂI¹³¼g¤½¦¡,
¨Ò¦p:
if a>0 then
  b = 1
  c = 5
  d = 12
end if

§Ú²ßºD¼g¦¨:
if a>0 then  b = 1:  c = 5:  d = 12

¬Ý§O¤H¼gªºµ{¦¡½X, ·|µo²{¨C¤H³£¦³²ß©Ê, ¥u­n¬Ý±oÀ´´N¦n~~

TOP

(3) ÂkÃþ ¤è«K¤£¥Î§äµ²§ôÂI

TOP

¦^´_ 5# ­ã´£³¡ªL


­ì¨ÓÁÙ¦³³oºØ¥Îªkªº·N«äªü
¨ü±Ð¤F ÁÂÁÂ~^^

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD