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

[µo°Ý] Àx¦s®æ§PÂ_¦¡Ä²µo¥¨¶°°ÝÃD

[µo°Ý] Àx¦s®æ§PÂ_¦¡Ä²µo¥¨¶°°ÝÃD

¦U¦ì¤j¤j¦n
       ¤p§Ì§Ú·Q¼g¤@­Ó¬ö¿ýµ{¦¡¡A·í¬í¼Æ¨ì¹F²Å¦X±ø¥ó®É¡AÀx¦s®æc1=1
¦¹®É§Ú·Q¥Îc1=1³o­Ó±ø¥óÅܼƨÓIJµo¥¨¶°¡A¦ý¬O§Úµo²{¥¨¶°¦ü¥G¤£·|°Ê!!
¥i§_À°§Ú¬Ý¤@¤U¬O­þ¸Ìªº°ÝÃD!!
ÁÂÁ¤j®a!!
:D


Book1.rar (6.51 KB)

¦^´_ 1# lichang
  1. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
  2.    '³o¬OThisWorkbook¼Ò²Õªº¹w³]¨Æ¥ó
  3.   If Range("C1") = "1" Then
  4.       Autoorder = MsgBox("¦³°õ¦æ")

  5.   End If
  6. End Sub
  7. Private Sub Worksheet_Calculate()
  8.      '½Ð§ï¥ÎWorksheet¼Ò²Õªº¹w³]¨Æ¥ó
  9.       If Range("C1") = "1" Then Autoorder = MsgBox("¦³°õ¦æ")
  10. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 2# GBKEE

·PÁ±z³o»ò¨³³t¦a¦^µª¡A§Ú·|¦n¦n½m²ßªº!!
:$

TOP

¦^´_ 2# GBKEE

¤j¤j§A¦n
§Ú²{¦b¹J¨ì¤@­Ó«Ü©_©Çªº°ÝÃD!!
¬°¤°»ò§Ú¦P¼Ëªº¼gªk¡A¦b¤@¥x´ú¸Õ¬OOKªº
¦ý¬O¦b¥t¥~¤@¥x´ú¸Õªº®É­Ôµo¥Í
¤@µ§¸ê®Æ¦P®É°O¿ý¨â¦¸¡A
§Ú¸Ó«ç»òÁ׶}°ÝÃD©O??

TOP

¦^´_ 4# lichang
   
¤@µ§¸ê®Æ¦P®É°O¿ý¨â¦¸
¬Ý¬Ý§AªºÀÉ®×
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

ÁÂÁ¤j¤j
§Ú¦Û¦æ¨Ï¥Î®É¶¡Å@Âꪺ¤è¦¡¨Ó­­©w¶È°O¿ý¤@µ§ªº°Ê§@!!
ÁÂÁÂ!!

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD