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

Dim©w¸q°ÝÃD

Dim©w¸q°ÝÃD

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-12-15 21:59 ½s¿è

1. vba¥i¥H³o¨Ç©w¸q¶Ü?
dim i!  '©w¸qi¬°single«¬
dim i#  '©w¸qi¬°Double«¬
dim i@  '©w¸qi¬°Currence«¬
dim i$  '©w¸qi¬°String«¬
dim i%  '©w¸qi¬°Integer«¬
dim i&  '©w¸qi¬°Long«¬

2. ¥Îdim i% ©M dim i as Integer ¦³¨S¦³¤À§O?
3. ¥ÎLong ·|¤ñInteger ªº­pºâ³t«×§Ö¶Ü?
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

²Ä¤@­Ó°ÝÃD:¥i¥H
¨ä¾l°ÝÃD«Ýª©¥D¸Ñµª§a
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2010-12-15 20:34 ½s¿è

¦^´_ 1# basarasy
3. ¥ÎLong ·|¤ñString ªº­pºâ³t«×§Ö¶Ü????
VBA ªº»¡©ú
Integer ÅܼƫY¥H½d³ò¬° -32,768 ¨ì 32,767 ¤§ 16 ¦ì¤¸ (2 ­Ó¦ì¤¸²Õ) ¼Æ¦rªº§Î¦¡Àx¦s¡CInteger ªº«¬ºA«Å§i¦r¤¸¬O¦Ê¤À¤ñ²Å¸¹(%)¡C
String¤§¦r¤¸½Xªº½d³ò±q 0 ¨ì 255¡C¦r¤¸¶°ªº«e 128 ­Ó¦r¤¸ ( 0 ¨ì 127 ) ¹ïÀ³©ó¼Ð·Çªº U.S Áä½L¤Wªº¦r¤¸»P²Å¸¹¡C³o«e 128 ¦r¤¸»P ASCII ¦r¤¸¶°¤¤©Ò©w¸qªº¬Û¦P¡C«á 128 ¦r¤¸ (128 ¨ì 255) «h¥Nªí¯S®í¦r¤¸¡A¨Ò¦p°ê»Ú¦r¤¸¡A­«­µ²Å¸¹¡A³f¹ô²Å¸¹¤Î¤À¼Æ¡CString ªº«¬ºA«Å§i¦r¤¸¬° ($)¡C
Long (ªø¾ã¼Æ)ÅܼƫY¥H½d³ò±q -2,147,483,648 ¨ì 2,147,483,647 ¤§ 32 ¦ì¤¸ (4 ­Ó¦ì¤¸²Õ) ¦³¸¹¼Æ¦r§Î¦¡Àx¦s¡CLong ªº«¬ºA«Å§i¦r¤¸¬° (&)¡C

TOP

¦^´_ 3# GBKEE

sorry.¥´¿ù¤F><.
2. ¥Îdim i% ©M dim i as Integer ¦³¨S¦³¤À§O?
3. ¥ÎLong ·|¤ñInteger ªº­pºâ³t«×§Ö¶Ü?(¼g¶}vbªº¤H»¡ªº)
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 4# basarasy


¥Îdim i% ©M dim i as Integer ¦³¨S¦³¤À§O?    ¨â­Ó±Ô­z¬O¤@¼Ëªº
¥ÎLong ·|¤ñInteger ªº­pºâ³t«×§Ö¶Ü?(¼g¶}vbªº¤H»¡ªº)   
¸ê®Æ«¬ºA¬O¬°¤F½T©w«¬ºA¦Ó«Å§i¡A«D¦]«¬ºA¤£¦P¦Ó¦³°õ¦æ³t«×¤§®t¡A
¦³«Å§i·|¤ñ¨S«Å§i§Ö¡A¦ý¤£¦P«¬ºA·|²£¥Í¤£¦P¼Æ­È½d³ò
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

1. ·íµM¥i¥H! ¦]¬°®v¥X¦Pªù^^"
2. ¥Îdim i% ©M dim i as Integer ¦³¨S¦³¤À§O? ¤@­Ó¬O²¼g,¤@­Ó¬O§¹¾ã¼gªk~ ¨Ï¥Î¤WµL¥ô¦ó®t²§!
3. ¥ÎLong ·|¤ñInteger ªº­pºâ³t«×§Ö¶Ü? ¦pªG³£¬O­n¥L­Ì¼Æ1~10,¨º³t«×¬O¤@¼Ëªº! ¥L­Ìªº®t²§¬O¦b©ó«¬ºA,¤£¬O³t«×~
­Y¬O§Ú¦^µª¡A¨Ï±zº¡·N¡A½Ð±zÅý§Úª¾¹D¡I                  
­Y¬O§Úªº¦^ÂСA±z¤´¦³¨ä¥L¨£¸Ñ¡A¤]½Ð±z¤£¶Þ«ü±Ð¡I

TOP

ÁÂÁ¤j¤j­Ìªº«ü¾É.
§Ú¦Û¤v·|ı±o Integer¤ñ Long  ªº­pºâ³t«×§Ö(Åܼƽd³ò¦bInteger¤º)
,Integer¥Î(2 ­Ó¦ì¤¸²Õ)  Long  ¥Î (4 ­Ó¦ì¤¸²Õ).

ÁÙ¦³vbaªº­pºâ³t«×°ÝÃD.(§Úª¾¹D³o­Ó°ÝÃD¬O­nªø®É¶¡¾Ç²ßªº)
¦³¤°»ò¤èªk¥i¥H¥[§Ö­pºâ³t«×?
¬O§_¶V¤Övba½X´N·|§Ö?
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

§Ú¦Û¤v·|ı±o Integer¤ñ Long  ªº­pºâ³t«×§Ö(Åܼƽd³ò¦bInteger¤º)
,Integer¥Î(2 ­Ó¦ì¤¸²Õ)  Long  ¥Î (4 ­Ó¦ì¤¸²Õ).
¼Æ¦Ê¸U¤À¤§¤@¬íªº®t¶Z¥i¥H¤£¥²¥h­p¸û¡C½Ö§Ö½ÖºC´¿¦³¤H´ú¸ÕLong·|§Ö¨Ç¡A¤£¹L¥u­nÃþ«¬¥¿½T·Pı¤£¨ì®t²§ªº¡C
¦³¤°»ò¤èªk¥i¥H¥[§Ö­pºâ³t«×?
¥¿½Tªº¤èªk´N¬O³Ì§Öªº¤èªk¡C
¬O§_¶V¤Övba½X´N·|§Ö?
¥¿¦n¬Û¤Ï¡I

TOP

¦^´_ 8# oobird

    Worksheets("Sheet1").Range("A1").Value = "100"  ·|¤ñ Range("A1").Value = "100"  §Ö?
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 9# basarasy

°ò¥»¤W§A³o­Ó±Ô­z¬O¤@¼Ò¤@¼Ëªº
¨S¦³§ÖºC¤§¤À
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD