资源描述:
《vba常用函数(vba common functions)》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、vba常用函数(VBAcommonfunctions)VBAstringfunctionlistTrim(string)removesstringorsoatbothendsLtrim(string)removestheleftspaceofthestringRtrim(string)removestherightmarginofthestringLen(string)calculatesthelengthofstringLeft(string,x)takesthestringofXcharactersfromt
2、heleftstringsectionRight(string,x)takesthestringofXcharactersfromtherightsectionofthestringMid(string,start,x)takesthestringofXcharactersstartingfromthestartbitofstringUcase(string)convertedtouppercaseLcase(string)isconvertedtolowercaseSpace(x)returnsxblankst
3、ringsAsc(string)returnsaintegerthatrepresentsthecharactercodeoftheinitialcharacterinthestringChr(charcode)returnsstring,whichcontainscharactersrelatedtothespecifiedcharactercodeListofVBAconversionfunctionsCBool(expression)isconvertedtotypeBooleanCByte(express
4、ion)isconvertedtotypeByteCCur(expression)isconvertedtotypeCurrencyCDate(expression)isconvertedtotypeDateCDbl(expression)isconvertedtotypeDoubleCDec(expression)isconvertedtotypeDecemalCInt(expression)isconvertedtotypeIntegerCLng(expression)isconvertedtotypeLon
5、gCSng(expression)isconvertedtotypeSingleCStr(expression)isconvertedtotypeStringCVar(expression)isconvertedtotypeVariantVal(string)isconvertedtodatatypeStr(number)isconvertedtoStringVBAtimefunctionNowreturnsaVariant(Date)thatspecifiesthedateandtimebasedontheda
6、teandtimethecomputersystemisset.DatereturnstheVariant(Date)thatcontainsthedateofthesystem.TimereturnsaVariant(Date)thatindicatesthecurrentsystemtime.TimerreturnsaSinglerepresentingthenumberofsecondspassedfrommidnighttonow.TimeSerial(hour,minute,second)returns
7、aVariant(Date)containingtime,minutes,andseconds.DateDiff(interval,date1,date2[,firstdayofweek[,firstweekofyear]])returnsthevalueofVariant(Long),indicatingthenumberoftimeintervalsbetweentwospecifieddatesSecond(time)returnsaVariant(Integer)withanintegervaluebet
8、ween0and59,representingasecondinoneminuteMinute(time)returnsaVariant(Integer)withanintegervaluebetween0and59,representingaminuteinanhourHour(time)returnsaVariant(Integer),whosevalueisanin