.
.
鎸?/p>
瀛?/p>
姣?/p>
椤?/p>
搴?/p>
鎺?/p>
鍒?/p>
:::::
[A]
====================================================
======================= Abs
鍑芥暟
杩斿洖鍙傛暟鐨勭粷瀵瑰�硷紝
鍏剁被鍨嬪拰鍙傛暟鐩稿悓銆?/p>
璇硶
Abs(number)
蹇呰鐨?/p>
number
鍙傛暟鏄换浣曟湁鏁堢殑鏁板�艰〃杈惧紡锛屽鏋?/p>
number
鍖?/p>
鍚?/p>
Null
锛屽垯杩斿洖
Null
锛屽鏋?/p>
number
鏄湭鍒濆鍖栫殑鍙橀噺锛屽垯杩斿洖
0
銆?/p>
璇存槑
涓�涓暟鐨?/p>
缁?/p>
瀵?/p>
鍊?/p>
鏄?/p>
灏?/p>
姝?/p>
璐?/p>
鍙?/p>
鍘?/p>
鎺?/p>
浠?/p>
鍚?/p>
鐨?/p>
鍊?/p>
銆?/p>
渚?/p>
濡?/p>
锛?/p>
ABS(-1)
鍜?/p>
ABS(1)
閮?/p>
杩?/p>
鍥?/p>
1
銆?/p>
--------------------------------------------------------------------------
Abs
鍑芥暟绀轰緥
鏈ず渚嬩娇鐢?/p>
Abs
鍑芥暟璁＄畻鏁扮殑缁濆鍊笺�?/p>
Dim MyNumber MyNumber = Abs(50.3) '
杩?/p>
鍥?
50.3
銆?
MyNumber
=
Abs(-50.3)
'
杩?
鍥?
50.3
銆?/p>
====================================================
======================= Array
鍑芥暟
杩斿洖涓�涓寘鍚暟缁勭殑
Variant
銆?/p>
璇硶
Array(arglist)
鎵�闇�鐨?/p>
arglist
鍙傛暟鏄竴涓敤閫楀彿闅斿紑鐨勫�艰〃锛岃繖浜涘�肩敤浜庣粰
Variant
鎵�
鍖呭惈鐨勬暟缁勭殑鍚勫厓绱犺祴鍊笺�?/p>
濡傛灉涓嶆彁渚涘弬鏁帮紝
鍒欏垱寤轰竴涓暱搴︿负
0
鐨勬暟缁勩�?/p>
璇存槑
鐢ㄦ潵琛?/p>
绀烘暟缁勫厓绱犵殑绗﹀彿鐢卞彉閲忓悕銆佸渾鎷彿浠ュ強鎷彿涓殑鎵�闇�鍏冪礌鐨勭储寮曞彿缁勬垚銆傚湪涓嬮潰鐨勭ず渚?/p>
涓紝绗竴鏉¤鍙ュ垱寤轰竴涓?/p>
Variant
鐨勫彉閲?/p>
A
銆?/p>
绗簩鏉¤鍙ュ皢涓�涓暟缁勮祴缁欏彉閲?/p>
A
銆傛渶鍚?/p>
涓�鏉¤鍙ュ皢璇ユ暟缁勭殑绗簩涓厓绱犵殑鍊艰祴缁欏彟涓�涓彉閲忋�?/p>
Dim A A = Array(10,20,30) B =
A(2)
浣跨敤
Array
鍑芥暟鍒涘缓鐨勬暟缁勭殑涓嬬晫鍙?/p>
Option
Base
璇彞鎸囧畾鐨勪笅鐣岀殑鍐冲畾
,
闄ら潪
Array
鏄敱绫诲瀷搴?/p>
锛堜緥濡?/p>
VBA.Array )
鍚嶇О闄愬畾銆?/p>
濡傛灉鏄敱
绫诲瀷搴撳悕绉伴檺瀹氾紝
鍒?/p>
Array
涓?/p>
鍙?/p>
Option Base
鐨勫奖鍝嶃�?/p>
娉ㄦ剰
娌℃湁浣滀负鏁扮粍澹版槑鐨?/p>
Variant
涔熷彲浠ヨ〃绀烘暟缁勩�傞櫎浜嗛暱
搴﹀浐瀹氱殑瀛楃涓蹭互鍙婄敤鎴峰畾涔夌被鍨嬩箣澶栵紝
Variant
鍙橀噺鍙互琛ㄧず浠讳綍绫诲瀷鐨勬暟缁?/p>
銆傚敖绠′竴
涓寘鍚暟缁勭殑
Variant
鍜屼竴涓厓绱犱负
Variant
绫诲瀷鐨勬暟缁勫湪姒傚康涓婃湁鎵�涓嶅悓锛屼絾瀵规暟缁?/p>
鍏?
绱?
鐨?
璁?
闂?
鏂?
寮?
鏄?
鐩?
鍚?
鐨?
銆?/p>
--------------------------------------------------------------------------
Array
鍑?/p>
鏁?/p>
绀?/p>
渚?/p>
璇ョず渚嬩娇鐢?/p>
Array
鍑芥暟鏉ヨ繑鍥炰竴涓寘鍚?/p>
Variant
鐨勬暟缁勩�?/p>
Dim
MyWeek,
MyDay
MyWeek = Array("Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun") '
杩斿洖鍊煎亣璁句笅鐣岀殑