vba常用函数（VBA common functions）.doc

vba常用函数（VBA common functions） VBA string function list Trim (string) removes string or so at both ends Ltrim (string) removes the left space of the string Rtrim (string) removes the right margin of the string Len (string) calculates the length of string Left (string, x) takes the string of X characters from the left string section Right (string, x) takes the string of X characters from the right section of the string Mid (string, start, x) takes the string of X characters starting from the start bit of string Ucase (string) converted to uppercase Lcase (string) is converted to lowercase Space (x) returns x blank strings Asc (string) returns a integer that represents the character code of the initial character in the string Chr (charcode) returns string, which contains characters related to the specified character code List of VBA conversion functions CBool (expression) is converted to type Boolean CByte (expression) is converted to type Byte CCur (expression) is converted to type Currency CDate (expression) is converted to type Date CDbl (expression) is converted to type Double CDec (expression) is converted to type Decemal CInt (expression) is converted to type Integer CLng (expression) is converted to type Long CSng (expression) is converted to type Single CStr (expression) is converted to type String CVar (expression) is converted to type Variant Val (string) is converted to data type Str (number) is converted to String VBA time function Now returns a Variant (Date) that specifies the date and time based on the date and time the computer system is set. Date returns the Variant (Date) that contains the date of the system. Time returns a Variant (Date) that indicates the current system time. Timer returns a Single representing the number of seconds passed from midnight to now. TimeSerial (hour, minute, second) returns a Variant (Date) containing time, minutes, and seconds. DateDiff (interval, date1, date2[, firstdayofweek[, firstweekofyear]]) returns the value of V