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

VBA°õ¦æ«á¡A¤½¦¡«hµLªk°õ¦æ

VBA°õ¦æ«á¡A¤½¦¡«hµLªk°õ¦æ

·Q½Ð°Ý¦U¦ì«e½ú¡A§Ú°õ¦æVBA¦h¤u§@­¶­±«á(¬Y¨ÇÀx¦s®æ¸ê®Æ§R°£©Î§ó°Ê)¡F
¦Ó³¡¤Àªº¤½¦¡·|°±¤î¹Bºâ¡A¹Bºâªºµ²ªG·|¬°­ì¥»¥¼°õ¦æVBA«eªºµ²ªG
­Y¦b¤½¦¡Àx¦s®æ¤º¦A­«·s°õ¦æ¤@¦¸(¹«¼Ð¤º¸m©ó¤½¦¡¤¤¡A¦A°õ¦æENTER)¡A«h·|«ì´_¹Bºâ
¬O§_¦]¬°VBA§R°£¤F¤½¦¡ªº¹Bºâ¨Ó·½¡A©Ò¥H¤½¦¡¤~µLªk¹Bºâ?

¦³¥i¯à¬O¨Ó·½»P¥Øªº ³Q VBA ­×§ï¹L

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 2# mark15jill


    ©Ò¥H¥u­n¥HVBA§ïÅܤ½¦¡¨Ó·½ªºÀx¦s®æ³¡¤À¡A¤½¦¡³£¤£·|¹Bºâ¶Ü?

TOP

¦^´_  mark15jill


    ©Ò¥H¥u­n¥HVBA§ïÅܤ½¦¡¨Ó·½ªºÀx¦s®æ³¡¤À¡A¤½¦¡³£¤£·|¹Bºâ¶Ü?
jackson7015 µoªí©ó 2012-11-23 08:32



    vba¸Ì¼g¤½¦¡´N¥i¥H...
¥Î²³æªº¤ß°µ½ÆÂøªº¨Æ

TOP

¥»©«³Ì«á¥Ñ mark15jill ©ó 2012-11-23 09:40 ½s¿è

¦^´_ 3# jackson7015


    Á|¨Ò¨Ó»¡..

¦pªG A1 = 1     B1=2      C1= A1+B1
¥i¥H¼g¦¨..PS.¥H¤U¨Ò¤l¥H¼Æ­È«¬ºA»¡©ú

[c1]=[a1]+[b1]

range("c1")=range("a1").value+range("b1")

[c1]="=sum(a1+b1)"   '¬õ¦r³¡¥÷ ªº¼gªkÃþ¦ü©ó ª½±µ¦bC1 ¤W ¿é¤J¤½¦¡ =sum(a1+b1)¡A¥u¬O«e«á­n+  " ' " ¡Aªí¥Ü¤å¦r«¬ºA

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 5# mark15jill
¦^´_ 4# BigDog
·PÁ«e½úªº«ü±Ð
§Úªº¤½¦¡¬O¦h­¶­±¦hÀx¦s®æ¡A¨Ó·½«h¥u¦³¯S©w¤@­¶­±
©Ò¥H­Y¬O¥þ³¡³£¥HVBA¨Ó½s¼g¡A¥þ³¡¤u§@­¶­±³£­n§ï¼g
¤~·Q½Ð°Ý¬O§_VBA§ïÅܤF¤½¦¡¨Ó·½¡A¤½¦¡¬O§_´N»Ý­n­«·s°õ¦æ¤~¯à§ì¨ú¨ì¨Ó·½¸ê®Æ

TOP

¦^´_ 6# jackson7015


    ±z­n¤£­n¶K¤W¤@¤p°ÝÃD½d¨Ò¡A¦nª¾¹D ±zªº©Ò¿×  ¦h­¶¦hÀx¦s®æ ¬O ­þÃþ«¬¡H
³sÄò? ¤£³sÄò?

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 1# jackson7015

¬O§_¦b¿ï¶µ³]©wªº¦Û°Ê­«ºâ³Q³]©w¦¨¤â°Ê­«ºâ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh
·PÁÂHsieh¤j¤jªº¦^À³
Àˬd¹L¿ï¶µ¤½¦¡³¡¤À¡A¬¡­¶Ã¯­pºâ¤è¦¡¬°¦Û°Ê¡F
¤£¾å±oÁÙ¦³­þ¨Ç³¡¤À·|¼vÅT¨ì¦¹ºØª¬ªp ?

TOP

¦^´_ 9# jackson7015


    ¤W¶ÇÀɮ׬ݬݡA§_«h½M¤lºN¶H¨S¿ìªkª¾¹D°ÝÃD©Ò¦b
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD