vba语言基础（VBA language foundation）.docVIP

vba语言基础（VBA language foundation） VBA language foundation Section 1 identifier I. definition An identifier is a symbol that identifies variables, constants, processes, functions, classes, and so forth, and uses them to complete references to variables, constants, processes, functions, classes, and so forth. Two. Naming rules 1) initial letters, consisting of letters, numbers, and underscores, such as A987b_23Abc 2) character length of less than 40, (more than Excel2002 Chinese version, etc., you can use Chinese characters, and the length of up to 254 characters) 3) with VB reserved word names, such as public, private, dim, goto, next, with, integer, single etc. Second section operator Definition: an operator is a symbol that represents the function of some VB operation. 1) assignment operator = 2) + (character, mathematical operator connector), + (plus), - (minus), Mod (take over), \ (divisible), * (x) / (except), - (minus), ^ (index) 3) logical operators Not (non), And (()), Or (or), Xor (Yi Huo), Eqv (equal), Imp (implicit) 4) the relational operators (the same) =, (range), (greater than), (less than) , = = (no less than), (not more than Like, and Is) 5) bitwise operators Not (logical, non), And (logic and), Or (logic or), Xor (logical XOR), Eqv (logic, etc.), Imp (implicit) Third section data type VBA has 12 data types, see the table below, and the user can customize the data type with Type, depending on the following type. Data type type identifier byte String type String $character length (0-65400) Byte type Byte with no 1 Boolean Boolean No 2 Integer type Integer% 2 Long integer type Long 4 Single precision Single! 4! Double Double # 8 Date type Date No 8 ad 100/1/1-9999/12/31 Currency type Currency @ 8 The decimal point type Decimal has no 14 Variant Variant, no more than any type, variable Object type Object, no 4 Fourth variables and constants 1) VBA allows undefined variables to be used, and defaults to variant variables. 2) in the module general des