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

[µo°Ý] Ãö©ó¦Û©w¸q¨ç¼ÆªººÃ´b

[µo°Ý] Ãö©ó¦Û©w¸q¨ç¼ÆªººÃ´b

³Ìªñ­è¶}©l±µÄ²VBA¡A
¦b¦Û©w¸q¨ç¼Æ³¡¥÷·Q­n½Ð°Ý¦U¦ì«e½ú...
¦³¤°»ò¤è¦¡¥i¥HÅý¦Û©w¸q¨ç¼Æ¤£¦Û°Ê°õ¦æ...
¤ñ¦p»¡¤U¤èªº¦Û©w¸q¨ç¼Æ¡A

Public Function ENT(RNG As Range)
MSGBOX RNG.VALUE
End Function

¨C¦¸¥u­n§Ú¶i¦æ½s¿è®É¡A¤£ºÞ¸Ì­±¦³µL¸ê®Æ¡A
¨C¦¸µ²§ô½s¿è´N·|¶i¥h°õ¦æENTªº¦Û©w¸q¨ç¼Æ¡A
¥u­n¦³¥Î¨ì¦Û©w¸q¨ç¼Æªº¦a¤è´N·|¶]¤@¦¸µ{§Ç¡A
¼Æ¶q¤@¦h´N·|©ìºC¨t²Î...
¤£ª¾¹D¦³¨S¦³¤è¦¡¥i¥H§ïµ½³o¼Ëªº°ÝÃD...
¨S¨Æ´N¨Ó³}³}

µL½×¤°»ò¨ç¼Æ,¤]·|"©ìºC"¨t²Î

¦b¹BVBA®É,¥i¥H¥Î³o­Ó°±±¼©Ò¦³¨ç¼Æ­pºâ
APPLICATION.CALCULATION=XLCALCULATIONMANUAL
¦b¦³Ãö­pºâ«á¦A¶}°Ê¦Û°Ê­pºâ
APPLICATION.CALCULATE
APPLICATION.CALCULATION=XLCALCULATIONAUTOMATIC

¨º¹B¦æVBA®É,¨S¥Îªº­«·s­pºâ´N¥i¥H¬Ù±¼
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

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

TOP

¦^´_ 2# kimbal
¶â~¤F¸Ñ¡A
·PÁª©¥Dªº¸Ñµª¡A
§Ú·|¦AµZ¿i¤@¤U¨Ï¥Îªº®É¾÷~THANKS~
¨S¨Æ´N¨Ó³}³}

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD