kimbal

dim ¬O¥Î¨Ó»s°µ¤W "¥i©ñªF¦èªº¾¹¥×" ºÙ¬°"Åܶq"
AS ¤§«áªº¬°"¾¹¥×"ªºÄÝ©Ê

³o¨Ç¬O©ñ¼Æ¦r(LONG,INTEGER)ªº¾¹¥×
Dim x as long
Dim y as integer
x=1  '§â1©ñ¶iX
y=2  '§â2©ñ¶iY
msgbox(x+y) '³o¥y§âX©MYªº¼Æ­È¥[Á`Åã¥Ü¥X¨Ó

³o¨Ç­Ó¤å¦r(STRING)ªº¾¹¥×
Dim S as STRING
S="ABC"
msgbox(S)'³o¥y§âS¤º®eÅã¥Ü¥X¨Ó


Dim arr(2) ¬O°}¦C
ARR(1)="A"
ARR(2)="B"
MSGBOX(ARR(1) & ARR(2)) '³o¥y§âARR(1)©MARR(2)ªº¤º®e¦X¨ÖÅã¥Ü¥X¨Ó,§Y"AB"
°}¦C³q±`¥Î©ó°j°é

¾ÇExcel VBAªººô¯¸:
http://forum.twbts.com/thread-6621-1-3.html

kimbal

1.©Ò¥H­Y­n¥[§Öµ{¦¡³t«×, ©Ò¥H«Å§i®É ,­Y¨Ï¥Î¤§Data ¤£·|¶W¹L65536µ§
    «h¥ÎDime x as integer ¸û¨Î.¹ï¶Ü ...
alex_wu µoªí©ó 2012-5-31 13:26

1. ¹ï. ¦pªG¥u¬O¤Q¼Æ­ÓÅܶq,³o­Ó¦~¥Nªº¹q¸£,³t«×¤À§O¤£·|«Ü¤j

2.
VARIANT ªº·N«ä¬O¥ô·NÃþ«¬, ¥Ñexcel¦Û¤v¥Ñ¤º®e³]©wÃþ«¬
dim abc as variant
abc = 123
³o¼ËabcªºÃþ«¬´N·|Åܦ¨ "variant/integer" §Yinteger

dim abc as variant
abc = "def"
abcªºÃþ«¬´N·|Åܦ¨ "variant/string"

Dim arr(x) as integer
¤£¬O"°}¦Cx", ¦Ó¬O¦³ X+1 ­Ó­Èªº"°}¦CARR"
¨Ò¦p
Dim abc(3) as integer
¸ò³o4¦æÃþ¦ü
Dim abc1 as integer
Dim abc2 as integer
Dim abc3 as integer
Dim abc4 as integer

³]©w¼Æ­È®É:
abc(0)=1
abc(1)=2
abc(2)=3
abc(3)=4
¬Û¹ï©ó
abc1=1
abc2=2
abc3=3
abc4=4

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¥¨¶°¤¤¾Ç²ß.