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

[µo°Ý] excel VBA ¦Û°Ê§ó·s¿z¿ï°ÝÃD

¥»©«³Ì«á¥Ñ singo1232001 ©ó 2021-7-26 00:16 ½s¿è

¦^´_ 1# jsc0518


¥ý»¡©ú¤@¤U
§Ú¼gªº«Ü¤ßµê
¥i¯à·|¦³¤@°ï©_©Çbug
´N·í§@°Ñ¦Ò ª±¬Ý¬Ý

§Ú»{¬°³Ì¦³¥i¯à¥X²{ªºbug ¦b©ó §ó¤§«áªº¹B¥Î
¤]´N¬O·í§A§â¯u¹ê¸ê®Æ©ñ¤J
©ÎªÌ¾Þ§@¤@¨Ç½d¨Ò¥~ªº¸ê®Æ
¥i¯à´N·|²£¥Í¥¼ª¾bug
¤×¨ä¬O afÄæ ²M°£¸ê®Æ ©ÎªÌ ¬ðµM·s¼W¸ê®Æ
¸ê®Æ°O±o­n³Æ¥÷ ¨Ã¥B ¥ý¦æ¹ê»Ú´ú¸Õ ¦UºØ¾Þ§@ ³á

¥t¥~¸Ì­±¦³¤@¨Ç²ÖÂتºµ{§Ç §Ú¨S±þ±¼ ¤ñ¦prdÅܼÆ
¦]¬°§Ú·Q»¡ ¥i¯à·|¦³bug ¤£´±¶Ã§R ©ÎªÌ¤§«á­×§ï­n¥Î¨ì

error v1.zip (27.02 KB)

TOP

¥»©«³Ì«á¥Ñ singo1232001 ©ó 2021-7-26 04:51 ½s¿è

¦^´_ 22# n7822123


    §Úª±¥X¤@¨Ç·sªá¼Ë
1.³]¸m¤F¤@­Ó¦Û°Ê¿z¿ïªºÄ²µo¨Æ¥ó
2.ª½±µ§ä¥X¦Û°Ê¿z¿ï¤ºªº¸ê®Æ

¶¶«K¸É¥R ¥þ¿ï.On=false ªº®É­Ô ¤º³¡¨S¦³¸ê®Æ¯à¬d
»ª¦ü·Ó­ì¥»ªº¤è¦¡ ¥Î¦r¨å¥h§R­«½Æ´N¥i¥H

¦U¦ì¥[ªo ¥ý¾Ô¨ì³o¸Ì ·Rµt¤F= =

error v3.zip (106.91 KB)

TOP

¦^´_ 23# singo1232001


³o¬O¦bºô¸ô¤W¬d¨ìªº   
Application.AfterCalculate IJµo¨Æ¥ó

https://stackoverflow.com/questions/67027407/excel-vba-instantiate-aftercalculate-event-handler-when-opening-workbook

°µ­Ó²³æªº½d¨Ò µ¹¤j®a°Ñ¦Ò¤@¤U
¤£¹L­n¤p¤ß³]¸m
ÁקK³sÄòIJµo ¾É­Pexcel±Y¼ì

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD