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

¦³3­Ó°ÝÃD

¦³3­Ó°ÝÃD

²Ä1   §Ú¨£¤H¼gIF®É³£¦³END IF  ¦ý§Ú¤£¼gEND IF  ³£ÉN¥X¿ù,¨ºEND IF  ¦³¤°»ò¥Î?
²Ä2  ¥i¥H¥ÎVBA  ¶}¤£«H¥ôªºEXCEL®É¥ÎAUTO_OPEN ªºVBA¶Ü?
²Ä3  ¨Ï¥ÎªÌ¦Û­q¼Æ³o¼Ë¼g¿ù¤F¤°»ò?
½Ð¤j¤j«ü¾É«ü¾É.
hyh.JPG
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

²Ä1   §Ú¨£¤H¼gIF®É³£¦³END IF  ¦ý§Ú¤£¼gEND IF  ³£ÉN¥X¿ù,¨ºEND IF  ¦³¤°»ò¥Î?
²Ä2  ¥i¥H¥ÎVBA  ¶}¤£«H¥ô ...
basarasy µoªí©ó 2010-7-22 19:54



    ¦^§A¤@,¤T

¤@, ¦pªG§PÂ_±ø¥ó¤Uªº¥]¬Aªº¥u¦³¤@¥y, ´N¤£¥Îend if
¦p
if a=b then c=1
d=1

·íaµ¥©ób ªº®É­Ô c=1 ·|¹B¦æ d=1·|¹B¦æ
·ía¤£µ¥©ób ªº®É­Ô c=1 ¤£·|¹B¦æ¦ý d=1·|¹B¦æ

¤T,§A¬O·Q¦b¤u§@­¶¥Î³o­Ófunction? §â³o¬q©ñ¦bmodule¤W´N¥i
Public Function myDate(n As Variant) As Long
Application.Volatile
myDate = Range("A2").Value * n
End Function
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 2# kimbal

ÁÂÁÂkimbal¤j¤j.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 1# basarasy

¥t¥~¬O¦³Ãö²Ä2­Ó°ÝÃD, ¥i¥H°Ñ¦Ò¤@¤U³o¸Ì
    http://office.microsoft.com/zh-t ... 031999.aspx?redir=0
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 4# kimbal


    ³o­Ó§Úª¾¹D.
3ªº°ÝÃD  §Ú©ñ¦bmodule³£¤£¯à¥Î.

vba.rar (11.83 KB)

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

Function BSS(n As Integer) As Long
¤£¬Olnteger
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh
Function myDate(n As Integer) As Long
Application.Volatile
myDate = Range("A2").Value * n
End Function
³o­Ó§Ú¬O¬Ý®Ñªº.
¬°¤°»ò¤£¥i¥H¥ÎInteger??
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 7# basarasy


    ¬O§A¿é¤J¿ù¤F,¬O i ªº¤j¼g
¤£¬OLªº¤p¼g
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh
ÁÂÁ¤j¤jªº´£ÂI.
½Ð°Ý ¤J Integerªº¦a¤è¦³ÉN 1­Ó¦h¥Î³~ªº¦r?
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 9# basarasy


    «ç¼Ë¸û¦h¥Î³~?
¥L¬O¸ê®Æ«¬ºA
´N¬O«Å§i¸ÓÅܼƪº¸ê®Æ«¬ºA
½Ð°Ñ¦ÒVBA»¡©ú
Integer ÅܼƫY¥H½d³ò¬° -32,768 ¨ì 32,767 ¤§ 16 ¦ì¤¸ (2 ­Ó¦ì¤¸²Õ) ¼Æ¦rªº§Î¦¡Àx¦s¡CInteger ªº«¬ºA«Å§i¦r¤¸¬O¦Ê¤À¤ñ²Å¸¹(%)¡C
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD