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

[µo°Ý] Àx¦s®æ¥X²{®æ¦¡¬°¤å¦r©Î¶}ÀY¬°³æ¤Þ¸¹ªº¿ù»~

[µo°Ý] Àx¦s®æ¥X²{®æ¦¡¬°¤å¦r©Î¶}ÀY¬°³æ¤Þ¸¹ªº¿ù»~

Book1.rar (253.46 KB)
½Ð°Ý¬°¤°»ò³o­Óexcel Àx¦s®æ·|¥X²{¿ù»~¡H¥¦·N«ä»¡®æ¦¡¬°¤å¦r©Î¶}ÀY¬°³æ¤Þ¸¹¡A¬°¤°»ò·|³o¼Ë¡H¦³¤°»ò¸Ñ¨M¤èªk¡AÅý¥H«á¤£¥X²{³o­Ó°ÝÃD¡H

¦^´_ 1# 198188

¸ê®Æ­åªR
play.gif
2013-1-9 22:40
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


   ½Ð°Ý¬O¤°»ò­ì¦]¾É­P³o¼Ëªº¡H¦³¤°»ò¤èªk¥i¥HÁקK¡H¦]¬°³oºØ±¡ªp¸g±`µo¥Í¡C§ï§¹¤F¡A¤S¥X²{¡C

TOP

¦^´_ 3# 198188
³oÃþ°ÝÃD±`¬O¥Ñ¨ä¥L³nÅéÂà¤J©Î¬Oºô­¶½Æ»s¶K¤W
­Y¬O¤W­z±¡ªp¥i¯à¥u¦³ÂǥѸê®Æ­åªR¨Ó­×¥¿
ÁÙ¦³¤@ºØ¥i¯à¬O§Aªº¤u§@ªíÀx¦s®æ¼Ë¦¡ªº¼Æ値®æ¦¡³]©w¦¨¤å¦r¡A©Ò¥H¿é¤J¼Æ¦r¤]·|³Q¦s¦¨¤å¦r
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    ½Ð°Ý¡G
¦pªG¤@­ÓexcelùØ­±¬O¯Â¤å¥ó¨S¦³¥ô¦óµ{¦¡¡A¨º»ò·|¤£·|¦³´XMB?
¥t¥~vba¦pªG¨C¦¸¹B¦æ«á¡A·|§_¥[¤jexcelªº®e¶q¡H

TOP

¦^´_ 5# 198188
http://forum.twbts.com/thread-4577-1-2.html
³y¦¨ÀÉ®×µê­Dªº­ì¦]¤Ó¦h¤F
¥ô¦ó¤@­Ó¾Þ§@³£·|³Q°O¿ý¤U¨Ó
VBA¹ïÀɮ׸ê®Æªº¾Þ§@¥²¶·ºÉ¥i¯à¥u¹ï³Ì¤p¸ê®Æ½d³ò°µ¾Þ§@
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh

¨º»ò½Ð°Ý¦³¨S¦³¿ìªkÁÙ­ì©ÎÁY¤p®e¶q¡A¦]¬°§Ú­ì¥»ªºÀɮפ£°÷1MB¡A¹B¦æ¤Fvba®e¶q³ºµMÅܦ¨8-10MB,¤§«á¸Õ¹L§ï°Ê¤Ö³\µ{¦¡¡AµM«á®e¶q´NÅܦ¨25MB.
¥t¥~¦pªG¥u¦³¤å¦rµL¥ô¦óµ{¦¡¡A¤º®e¥u¦³¤å¥ó¨S¦³¨ä¥L¡A¯Â¸Hdata entry ¦ý¬°¦ó·|¦³¥i¥H¥h¨ì´XMB?¦³¤èªk¸Ñ±Ï¶Ü¡H
¥t¥~§Ú·Q°Ý¬°¦ó¨C¦¸¥´excel³£·|¦Û°Ê±NÀx¦s®æªº®æ¦¡¥Ñ¼Æ­ÈÅܦ¨¤é´Á¡H¦³¨S¦³¿ìªk¸Ñ¨M¡H

TOP

¦^´_ 6# Hsieh

½Ð°Ý¦bexcel 2010 ª©ùØ
¥i§_³]©w±ø¥ó
A column ¤º¥]§t¦³¡§PMI¡¨¡A B column ´N·|ÅÜ©³¦â¡H

TOP

¦^´_ 6# Hsieh


    ½Ð°Ý

A1Àx¦s®æ¬O1000
B1Àx¦s®æ¬O20% deposit

¦pªG§Ú·QC1Àx¦s®æ¥X²{200
1000 x 20% = 200
Worksheets(customer).range("C1").Value = Worksheets(customer).range("A1") x Left((Worksheets("Oracle").Range("B1").Value), 3)
Worksheets(customer).range("C1").Value = Worksheets(customer).range("A1") * Left((Worksheets("Oracle").Range("B1").Value), 3)

§Ú¥H¤W¨â­Ó¼gªk³£¤£¦æ¡A½Ð°ÝÀ³¸Ó¦p¦óªí¹F¡H

TOP

¦^´_ 9# 198188
A1¬O¼Æ­Èµ´¹ï¨S°ÝÃD
B1¬O¤å¦r¡A¨º´N­n¬Ý¤å¦r¬O§_¦³³W«h
³£¬O2¦ì¼Æ¥[%¶Ü?
¦³¥i¯à5%©Î100%³o¼Ë«D2¦ì¼Æ¶Ü?
¬O§_»Pdeposit¤§¶¡³£¦³ªÅ®æ?
­Y¥H§Aªº¨Ò¤l¨Ï¥ÎLEFT¨ú3­Ó¦r¤¸
%²Å¸¹ÁÙ¬O·|±NLEFT¨ú¥Xªº20%µø¬°¤å¦r
¦Ó²£¥Í«¬ºA¤£²Å
¥i§Q¥ÎEvaluate¨ç¼ÆÂন­pºâ¦¡
  1. Sub ex()
  2. [C1] = Evaluate([A1] & "*" & Left([B1], 3))
  3. End Sub
½Æ»s¥N½X
play.gif
2013-2-8 10:33
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD