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

[µo°Ý] §ó·s¿Ã¹õ°ÝÃD

[µo°Ý] §ó·s¿Ã¹õ°ÝÃD

·Q½Ð°Ý¤@­Ó°ÝÃD(µ{¦¡½X¦p¤U):
sub ex()
Application.ScreenUpdating = False

...(§Ú­n«ç»ò¼Ë¦b¤£§ó·s¿Ã¹õ¡A§Q¥Î¥u§ó·sÀx¦s®æCells(1,"A")¨Ó«ùÄòÅã¥Ü°õ¦æ"¥¨¶°"ªº®É¶¡(¬í)©O?)

Application.ScreenUpdating = False
end sub

¤£¤Ó©ú¥Õ§Aªº¥Øªº,
ScreenUpdating ¥u¬O·|¥O Excel ªº¥¨¶°¤Î VBA ©ó°õ¦æ¨ä¶¡¤£·|¦b screen ¤W¬Ý¨ìÅܤÆ,
¦ý¦b­I´º¬O·|¤£¦Pªº,
¦pªG A1 ªºÀx¦s®æ¬O¦³§ï§ó, ¬O¤£·|¦]¬° screenupdating ³]©w¤F false ¦Ó¤£·|³QÅܧó¼Æ­È,
¥u¬O¦b§A screenupdating = true «e¬O¬Ý¤£¨ì.

TOP

³o­Ó±¡ªp³q±`·|¥ÎAPPLICATION.STATUSBAR="¶i«×..."
¦bEXCEL¤U¤èÅã¥Ü
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

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

TOP

³o­Ó±¡ªp³q±`·|¥ÎAPPLICATION.STATUSBAR="¶i«×..."
¦bEXCEL¤U¤èÅã¥Ü
kimbal µoªí©ó 2011-10-23 13:27


¨º¯uªº­n¬Ý¬Ý¬O«ç¼ËÀ³¥Î§a~~~
(§Úªñ¨Ó°µªº¼Æ­Ó project ¬O Application.Visible = False ªº )

TOP

¦^´_ 1# spermbank


   ¬JµMÃö³¬¿Ã¹õ§ó·s¡AÀx¦s®æÅܤƴN¬Ý¤£¥X¨Ó¤F
µ{¦¡³]­p¥²¶·¦X¥GÅÞ¿è¡A¤£¥i¤Ñ°¨¦æªÅ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

®¦®¦¡A±µÄ²VBA¤£²`¡A·íªìªº·Qªk¬O­Y¥i¥HÃö³¬¿Ã¹õ§ó·s¡A·Q»¡¥i¤£¥i¥H¥u¶È§ó·s¬Y½d³ò©Î¬YÀx¦s®æ¡A¦]¬°¦Û¤v³]­pªºµ{¦¡¡A­Y¤£Ãö³¬¿Ã¹õ§ó·s¡A¦ü¥G·|¸õ¨Ó¸õ¥h...

ÁÂÁ¦U¦ì¤j¤j«ü±Ð¡A§Ú¦A·Q·Q¦p¦ó³]­p^^

TOP

        ÀR«ä¦Û¦b : ¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶ÃµoµÊ®ð¡C
ªð¦^¦Cªí ¤W¤@¥DÃD