¦p¦ó¼g»yªk¡A¨Ì§Ç°õ¦æVBAµ{¦¡(¸ó¤£¦Pªº¤u§@ªí)

jsc0518

¦U¦ì¥ý¶i¡A§Ú¤§«e¦³¼g¹L¦b¦P¤@­Ó¤u§@ªí¤W¨Ì§Ç°õ¦æVBA
¦ý§Ú¦³³\¦hªº¤u§@ªí³£¦³¼gVBA®É¡A«oµLªk°õ¦æ¡A¬O§_­þ¸Ì»Ý­×¥¿
Step1 --> Sheet1
Step2 --> Sheet2
Step3 --> Sheet3

·PÁ¦U¦ì!



Public Sub RUN()
'¨Ì§Ç°õ¦æVBA
Step1
Step2
Step3
End Sub

Scott090

¦^´_ 1# jsc0518

¤u§@ªí1,¤u§@ªí2,¤u§@ªí3 ¤À§O¬°¤u§@ªí¦WºÙ.
Public Sub RUN()
'¨Ì§Ç°õ¦æVBA
    ¤u§@ªí1.Step1
    ¤u§@ªí2.  Step2
    ¤u§@ªí3. Step3
End Sub

jsc0518

¦^´_ 2# Scott090


­ì¨Ó¥u­n¦b«e­±¥[¤W¤u§@ªí¦WºÙ¼Ú

ÁÂÁ±zªº«ü¾É!

Scott090

¦^´_ 3# jsc0518


    ½Ðª`·N¡A ¦¹³Bªº¤u§@ªí¦WºÙ«üªº¬O ¤u§@ªíµ{¦¡¦WºÙ(code name)¡A
¤£¬O¤u§@ªí­¶­±©³¤U¨º­Ó¤u§@ªí­¶­±¦WºÙ¡C
¦bVBA½s¿èµøµ¡¤º¦³¤u§@ªíÄݩʪí¡Aªí¤¤¥i¥H¬Ý¨ì¡G
(name) ¡A³o¬O code name
name    ¡A³o¬O ­¶­±¦WºÙ

jsc0518

¦^´_ 4# Scott090

okok¡A«D±`ÁÂÁ§Aªº±Ð¾É¼Ú!