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

[µo°Ý] VBA debugªº§xÂZ

[µo°Ý] VBA debugªº§xÂZ

½Ð°Ý¥ý¶i¡G
¼g§¹µ{¦¡«á¸Õ°õ¦æ¡F¦p¦³»yªk©Î°õ¦æ¿ù»~¡A¤£¬O³£·|§â¨º¤@±ø¦³°ÝÃDªºµ{¦¡½XÅܦâ¼Ð¥Ü?
¤£ª¾«ç¦^¨Æ¡A ¥u¥X²{ Alert ªº¼ÐÅÒ¡A¦³°ÝÃDªºµ{¦¡½X¤£·|Åܦâ¼Ð¥Ü¡A¹ï°£¿ù«D±`ªº¤£¤è«K
¬O³]©wªº°ÝÃD? ÁÙ¬O ....
½Ð«ü¾É
Excel ª©¥»¬O 2010 ª©


¥t¡A½Ð°Ý Excel 2013 ª© ¦³¤º®r VBA help ? ¯¸¤º¤w¦³¤¯¤H´£¨ÑÂ÷½u help.

·Pı¤W没¦³¿ìªk, MS EXCEL VBA ¥u¯àTry & Error. ¦³ÂI¨¯­W.
¬O§_¦³¨ä¥L¥ý¶i, ª¾¹D©O?.
­Y¬O¨Ï¥ÎMS ACCESS VBA¼¶¼gµ{¦¡, °õ¦æ·í¦³¿ù»~®É, µ{¦¡·|°±¦bµo¥Í¿ù»~ªº¦a¤è.

TOP

¦^´_ 1# Scott090
¦³°ÝÃDªºµ{¦¡½X¤£·|Åܦâ¼Ð¥Ü¡A¹ï°£¿ù«D±`ªº¤£¤è«K
On Error ¥i¬Ývbaªº»¡©ú,¦ýµ{¦¡¤¤­nµ½¥Î¤§.
  1. Option Explicit
  2. Sub Ex()
  3.     On Error GoTo LL    'µ{¦¡½X¦³¿ù»~µL±ø¥ó,¸õ¨ìµ{§Ç¤¤ªº¬Y¼Ð°O©Î¦æ¸¹¡C
  4.     Sheet1.Activate
  5.     Sheet3.[Q1].Select
  6.     '***************
  7.     Sheet3.[QAAA1] = "AAA"
  8.     Exit Sub
  9. LL:
  10.     MsgBox "µ{¦¡°õ¦æ¶¥¬q¿ù»~: " & Err & vbLf & vbLf & Err.Description
  11.     Stop
  12.     Resume         'ªð¦^¿ù»~¦æªºµ{¦¡½X
  13.   'Resume Next     'Ä~Äò¤U¤@¦æµ{¦¡½X
  14. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

·Pı¤W没¦³¿ìªk, MS EXCEL VBA ¥u¯àTry & Error. ¦³ÂI¨¯­W.
¬O§_¦³¨ä¥L¥ý¶i, ª¾¹D©O?.
­Y¬O¨Ï¥ÎMS  ...
mmxxxx µoªí©ó 2014-11-11 14:52



    ¬O«Ü§x´b¡A­ì¨Ó Excel VBA ¬O·|°±¯d¦b¦³°ÝÃDªº«ü¥O¦æ¨Ã§â¸Ó¦æ«ü¥OÅܦâ
ÁÙ¬O§Ú°O¿ù¤F!?

TOP

¦^´_ 3# GBKEE

ÁÂÁ´£¨Ñªº¤èªk¡G
STOP
RESUME

TOP

¦n¤èªk, ¹ïªì¯Å¼¶¼gExcel VBAªº¤H, À°§U¤£¤Ö, »°§Ö§ïCode¥h.

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD