kimbal

¶â,ÁÂÁÂ,¹ï«Å§i¦³°ò¦ªº»{ª¾¤F
¥i¬O¬°¤°»ò­n§â¸ê®Æ¥á¨ì°}¦C¸Ì©O?
ª½±µ§âÀx¦s®æ¤ºªº¸ê®Æ¹Bºâ¤£¬O¸û§Ö¶Ü?
...
alex_wu µoªí©ó 2012-5-31 22:23

¥i¬O¬°¤°»ò­n§â¸ê®Æ¥á¨ì°}¦C¸Ì©O?
ª½±µ§âÀx¦s®æ¤ºªº¸ê®Æ¹Bºâ¤£¬O¸û§Ö¶Ü?
§Ú¤]Æg¦¨ºÉ¶q§â¸ê®Æ©ñ¦b­¶­±Àx¦s®æ¤W³B²z,
°}¦C³q±`¬O¥Î¨Ó§@¼È®É¦ì¸m,¤£¥Î§ä­Ó­¶­±¨Ó¥Î.
¨Ò¦p§â¤å¦r¤À©î
arr= split("ABC;DEF;GHG",";")->
arr(0) ·|Åܦ¨ABC
arr(1) ·|Åܦ¨DEF
arr(2) ·|Åܦ¨GHG

¥t¥~°Ý¤@¤U,¾Ç¤F«Å§i(Dim)¤§«á,¤U¤@¶¥¬q»Ý­n¾Ç¤°»ò©O?
¥i¥H¬Ý¤@¤U function/sub,  for/next, loop/while,
excel¬ÛÃöªº¬ORANGE() ªº¥Îªk.
³Ì²³æ¬O±q¿ý»s¥¨¶°¤¤¾Ç²ß.

alex_wu

ÁÂÁ¤ÀªR,­ì¨Ó°}¦Cªº¦n³B¬O°}¦C©Ò¥eªº¸ê·½¸û¤Ö.§Ú·Q·N«ä
À³¸Ó¬O-->°}¦C¦³¤@ÂI¹³¬O¶}¤F¥t¤@­Ó¤u§@ªí¨Ó¶i¦æ¹Bºâ.
(¦ý¹ê»Ú¬O³z¹L°}¦C¤º¸ê®Æ+¤½¦¡¶i¦æ¹Bºâ) ¬ðµM¦³ÂIÀ´¤F
ÁÂÁ¦U¦ì¤j¤j. (¹ï§Ú­Ì·s¤â¦Ó¥B,ÁÙ¬O¥ý¼ô±x­¶­±Àx¦s®æ¹Bºâ
¦A¤Á¤JVBAÀ³¸Ó¸û§Ö)
¤U¤@¶¥¬q¦A¬D¾Ô¬Ý¬Ý¥Ñ²©öªº¿ý»s¥¨¶° + °j°é¸Õ¸Õ , ÁÂÁ¤j®a

alumi

¶â,ÁÂÁÂ,¹ï«Å§i¦³°ò¦ªº»{ª¾¤F
¥i¬O¬°¤°»ò­n§â¸ê®Æ¥á¨ì°}¦C¸Ì©O?
ª½±µ§âÀx¦s®æ¤ºªº¸ê®Æ¹Bºâ¤£¬O¸û§Ö¶Ü?
...
alex_wu µoªí©ó 2012-5-31 22:23

1. Excel ¤u§@ªí, ¥»¨­´N¬O¤@­Ó¤j«¬ªº ¤Gºû°}¦C.
   ¦ý¥¦¨C¤@­ÓÀx¦s®æ, ¤£©w¤j¤p, ¥i¦s©ñ¦UÃþ«¬ºAªº¸ê®Æ»P¬ÛÃöÄÝ©Ê, ¬G¬Û¹ï¦Ó¨¥, ¬O¤ñ ³æ¤@«¬ºAªº°}¦C, ¯Ó¥Î§ó¦hªº°O¾ÐÅé.
   ÀuÂI: ¥iµø¤Æ

2. VBA ¤ºªº³æ¤@«¬ºA°}¦C, ¦bµ{¦¡°õ¦æ®É, ¨ä³t«×, »·¤ñ¦A¥h½Õ¥Î ¤u§@ªíªºÀx¦s®æ¸ê®Æ, ÁÙ­n¨Óªº§Ö.

alumi

¦^´_ 7# alex_wu

1.©Ò¥H­Y­n¥[§Öµ{¦¡³t«×, ©Ò¥H«Å§i®É ,­Y¨Ï¥Î¤§Data ¤£·|¶W¹L65536µ§
    «h¥ÎDim x as integer ¸û¨Î.¹ï¶Ü?
2.½Ð°Ý¥H¤U»{ª¾¹ï¶Ü ?
Dim arr(x) as Variant  --> «ü©w¸q°}¦Cxªº¸ê®Æ¬° ?? Variant¬O??
Dim arr(x) as string    --> «ü©w¸q°}¦Cxªº"¤º®e"¬°"¦r¦ê"
Dim arr(x) as integer  --> «ü©w¸q°}¦CXªº"¤º®e"¬°"¼Æ­È"
------------------------------------------------------------------------
·Pı¦³ÂI©Ç©Çªº.
X ¬°¾ã¼Æ­È, ¨ä­Èªº½d³ò¬° -32768 ~ 32767
¥i¥H³o¼Ë¤l«Å§i
Const  X as Integer = 32767
Dim Arr(x) as String    ' °}¦C¯Á¤Þ½d³ò¬° 0~32766
©ÎªÌ
Dim Arr(1 to X) as String ' °}¦C¯Á¤Þ½d³ò¬° 1  ~ 32767

­Y±z·Q¦bµ{¦¡½X¤¤, ©Ò«Å§iªº°}¦C, ¬O¥Ñ 1 ¶}©l, ¦Ó¤£¬O 0 ¶}©l,
½Ð¦b³Ì¤W­±¥[¤W¤@¦æ Option Base 1