alex_wu

ÁÂÁ¤G¦ì¤j¤j,¾Ç²ß¨ì¤F¤@¨Ç«Å§iÅܼƪºÆ[©À¤F.
¦ý¬O long »P integer ¦³¤°»ò®t²§©O?
¥t¥~°Ý¤@¤U,¥i¥H³o¼Ë«Å§i°}¦C¶Ü? Dime arr(x) ÁÙ¬O¥u¯à Dime(1)?
=================================
Dim x as long          ¾ã¼Æ? (­«ÂжÜ)
Dime x as Integer    ¾ã¼Æ? (­«ÂжÜ)
Dim x as string        ¦r¦ê
Dim arr(x)              °}¦C  (¥i¥H³o¼Ë«Å§i°}¦C¶Ü?)
=================================

alumi

DIM ¬O¥Î©ó«Å§iÅܼƦWºÙ »P Åܼƫ¬ºA
»yªk:
Dim ÅܼƦWºÙ as Åܼƫ¬ºA
½d¨Ò:
Dim I as Integer  ' «Å§i I ¬°¾ã¼Æ«¬ºA, ¨ä­È³Ì¤j»P³Ì¤p½d³ò¬° -32768 ~ 32767

¥ô¦ó¤lµ{¦¡ ¶}ÀY, ¥Î Dim ¶i¦æÅܼƪº«Å§i ¤Î¨Ï¥Î , ¬O¤@­Ó¨}¦nªº¼gµ{¦¡²ßºD.

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

alex_wu

¥t¥~°Ý¤@¤U®ç¶é©Î¨º¸Ì¦³±M·~¾ÇExcel VBAªººô¯¸¶Ü?
­Y¦³ªº¸Ü¥ç³Â·Ð¤À¨É¤§.·Q§V¤O¾Ç²ß¤§.