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

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

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

¦^´_ 20# singo1232001

«¢¡A¨S¿ù¡A¦nª±´N¦n°Õ~

§Ú¤]µo²{§Ú­è­èªº²Ä7¶µ»¡©ú¤£¤Ó§´·í¡A¬ö¿ý±ø¥ó¥Î "¤u§@ªíªº¥þ°ìÅܼÆ"¤ñ¸û¦n

ÀHµÛ¤u§@ªí´N¥iÂX¥R¤F (¸Ó¦³ªº¨Æ¥óµ{¦¡¡B¥þ°ìÅܼƭn¦³)

¦]¬°¥D­n¬O¿ï¤£­nªº¡A¿z¿ï±ø¥ó§âªÅ¥Õ¯Ç¤J(ªÅ¥Õ¤£¹LÂo)

§ó·sV2ª©¥»~~¥i¦Û¦æÂX¥Rª±¬Ý¬Ý¡AÂú§Î°µ¨ì³o¼Ë´N®t¤£¦h¹Æ


1.¥ô¤@ÄæÂI¿ï¨â¤U¥ªÁä¸õ¥Xªí³æ
2.ªí³æ·|¦Û°Ê§ì¸ÓÄæ²Ä2¦Cªº "¸ê®Æ¿z¿ï²M³æ"¡A¨Ã¨q¥X¨Óµ¹§A¿ï¾Ü
3.§â"­nªº"¥´¤Ä¡A«ö½T©w§Y¥i§¹¦¨¿z¿ï (µ{¦¡·|¦Û°Ê°O¿ý§A"¤£­n"ªº)
4.°²³]¸ÓÄæ¸ê®Æ¨S¦³ItemA¡A¦ý¬O²M³æ¦³¥´¤Ä¡A¸ÓÄæ¦h¤F¤@µ§¸ê®ÆItemA¡A¤]¤£·|¦Û°ÊÁôÂÃ
5.¤ä´©ÂX¥RNÄæ¡A"¤£­­AF"Äæ¡A¦ý¬O­Y¸ÓÄæ¦a2¦C¨S¦³"¸ê®Æ¿z¿ï²M³æ"¡Aªí³æ¤W¤£·|¦³ªF¦èµ¹§A¤Ä
6.³]©w±ø¥ó¥i¥H¬ö¿ý¨ìÀÉ®×Ãö³¬¡A¥ç§YÀÉ®×Ãö³¬¦A¶}±Ò¡A»Ý­n­«·s³]©w
7.¥Ø«e¥i¤ä´©2­Óªí®æ¡A­Y¦³§ó¦hªí®æ¡A½Ð¦Û¦æÂX¥R¤u§@ªí¤ºªºµ{¦¡¡BÅܼƧY¥i~~
8.ªí³æ½d³ò¤j·§¤ä´©¨q¥X30­Ó¿ï¶µ¡A¦A¦hÀ³¸ÓÅã¥Ü¤£¥X¨Ó¡A¥i¦Û¦æ­×§ïªí³æ & ªí³æµ{¦¡


Error_ªüÀsV2.rar (42.06 KB)
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¦^´_ 20# singo1232001

§Aªº§Ú¤]ª±¤@¤U¡A§Ú§â"¥Í²£¤¤"¨ú®ø¿z¿ï¡A¦A§âAFÄæ¦ì¬Y¤@®æ¿ï¦¨ "¥Í²£¤¤"

µ²ªG¿z¿ï±ø¥ó¤S¦³"¥Í²£¤¤"©Ô~~
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

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

¦^´_ 19# n7822123

Dear n7822123,
±z¦n¡I·PÁ±zªº¼ö¤ß¦^´_»P«ü¾É¼Ú¡I
©êºp°ÝÃD§Ú°Ýªº²¤¬°½ÆÂø¡C
¥D­n´N¬O±z©Ò´£¨ìªº¡G·Q¿ìªk°O¿ý "¨Ï¥ÎªÌ¤£­nªº" ¿ï¶µ
·P®¦Åo¡I
Just do it.

TOP

¦^´_ 20# singo1232001
Dear singo1232001,
·PÁ±zªº¦^ÂлP«ü¾É¼Ú¡I
§Ú¦A¨Ó¸Õ¸Õ¡I
Thank you.
Just do it.

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD