- 1、本文档共8页,可阅读全部内容。
- 2、有哪些信誉好的足球投注网站(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
- 5、该文档为VIP文档,如果想要下载,成为VIP会员后,下载免费。
- 6、成为VIP后,下载本文档将扣除1次下载权益。下载后,不支持退款、换文档。如有疑问请联系我们。
- 7、成为VIP后,您将拥有八大权益,权益包括:VIP文档下载权益、阅读免打扰、文档格式转换、高级专利检索、专属身份标志、高级客服、多端互通、版权登记。
- 8、VIP文档为合作方或网友上传,每下载1次, 网站将根据用户上传文档的质量评分、类型等,对文档贡献者给予高额补贴、流量扶持。如果你也想贡献VIP文档。上传文档
查看更多
vba常用函数(VBA common functions)
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
您可能关注的文档
- c语言复习资料(C language review materials).doc
- c语言字符串函数大全(C language string function Daquan).doc
- c语言实现飘动的红五星(C language with red).doc
- c语言实现顺序表的基本操作(C language to achieve the basic operation of the order table).doc
- c语言延时程序(C language delay program).doc
- c语言小游戏源代码《打砖块》(C language game source code playing bricks.).doc
- c语言播放声音文件的函数(The function of playing sound files in C language).doc
- c语言改错题技巧(C language error correction problem skills).doc
- c语言枚举类型举例(C language enumeration type example).doc
- C语言的布尔类型(_Bool)(The boolean type (_Bool) of the C language).doc
- 2025年高级软考考试历年机考真题集附答案详解【突破训练】.docx
- 2025至2030中国综艺节目行业产业运行态势及投资规划深度研究报告.docx
- 母婴用品店建设及运营背景分析.pdf
- 分而治之:税收组织结构与企业关联交易避税.pdf
- 中国特宽纯棉坯布行业市场发展前景及发展趋势与投资战略研究报告2025-2028版.docx
- 2025年高级软考考试历年机考真题集(历年真题)附答案详解.docx
- 2025年高级软考考试历年机考真题集附答案详解【巩固】.docx
- 2025年高级软考考试彩蛋押题【全国通用】附答案详解.docx
- 2025年高级软考考试历年机考真题集及答案详解(网校专用).docx
- 2025年高级软考考试历年机考真题集精选附答案详解.docx
文档评论(0)