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

[µo°Ý] §Ú·Q½Ð°ÝÃö©óCalculate¡BChange

[µo°Ý] §Ú·Q½Ð°ÝÃö©óCalculate¡BChange

½Ð°Ý¥H¤U¤T­Ó¤À§O®t¦b­þ
  1. '²Ä¤@­Ó
  2. Private Sub Workbook_SheetCalculate(ByVal Sh As Object)

  3. End Sub
  4. '²Ä¤G­Ó
  5. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

  6. End Sub
  7. '²Ä¤T­Ó
  8. Private Sub Worksheet_Calculate()

  9. End Sub
½Æ»s¥N½X
­n«ç»ò¨Ï¥Î´Á·|°_§@¥Î?

Workbook_SheetChange
¡Ä¬°¡e¬¡­¶Ã¯¡f¨Æ¥ó¡A¹ï¥þ³¡¤u§@ªí¦³®Ä

Worksheet_Change
¡Ä¬°¡e¤u§@ªí¡f¨Æ¥ó¡A¶È¹ï¸Ó¤u§@ªí¦³®Ä


¦³ªÅ¦h¬Ý¬ÝVBE¤º«Ø»¡©úÀÉ¡A¥Î¸Ì­±ªº½d¨Ò¥h´ú¸Õ¡ã¡ã

Change ¨Æ¥ó (SheetChange Event)
·í¨Ï¥ÎªÌ©Î¥~³¡³sµ²Åܧó¤u§@ªí¤¤ªºÀx¦s®æ®Éµo¥Í¡C

Calculate ¨Æ¥ó (Calculate Event)            
Chart ª«¥ó (Chart object)¡G¦b·sªº©ÎÅܧó¹Ïªíø¹Ï¸ê®Æ¤§«áµo¥Í¡C
Worksheet ª«¥ó (Worksheet object)¡G¦b¹ï¤u§@ªí­«·s­pºâ¤§«áµo¥Í¡C

©Î¥h¶R¥»ªì¶¥®Ñ¡A³o°ò¦ªº°ÝÃD¡e¨Æ¥ó¡Dª«¥ó¡DÄÝ©Ê¡D¤èªk¡D±`¼Æ....¡fÀ³¦Û¦æ¥h¬ã¨s¡A
§O¤H¤@®É¨S¿ìªk»¡­Ó©ú¥Õ¡ã¡ã

TOP

¦^´_ 2# ­ã´£³¡ªL


    ·PÁ¤j¤jªº­@¤ß¦^´_~

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD