文件名称:VBA
- 所属分类:
- 其他小程序
- 资源属性:
- [Excel]
- 上传时间:
- 2012-11-26
- 文件大小:
- 7kb
- 下载次数:
- 0次
- 提 供 者:
- funti*****
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
最简单的方法判断一个字符串中是否有汉字
VBA中默认英文字符串都是Unicode,双字节,如果转化为vbFromUnicode就变成单字节,
汉字还是双字节,如果转换之前的字符长度与转化之后的字节长度相等(LenB是计算字符的字节长度的函数),
说明不含中文字符,反之含有中文字符。-The simplest way to judge whether a string of Chinese characters have VBA in the default English strings are Unicode, double byte, if it becomes vbFromUnicode into single-byte, or double-byte characters, if characters in length prior to conversion and transformation byte after the same length (LenB is calculated byte characters in length function), indicating that non-Chinese characters, on the contrary contain Chinese characters.
VBA中默认英文字符串都是Unicode,双字节,如果转化为vbFromUnicode就变成单字节,
汉字还是双字节,如果转换之前的字符长度与转化之后的字节长度相等(LenB是计算字符的字节长度的函数),
说明不含中文字符,反之含有中文字符。-The simplest way to judge whether a string of Chinese characters have VBA in the default English strings are Unicode, double byte, if it becomes vbFromUnicode into single-byte, or double-byte characters, if characters in length prior to conversion and transformation byte after the same length (LenB is calculated byte characters in length function), indicating that non-Chinese characters, on the contrary contain Chinese characters.
相关搜索: vba
(系统自动生成,下载前可以参看下载内容)
下载文件列表
VBA.xls