vb函数大全VBfunctionDaquanWord格式.docx
- 文档编号:22927234
- 上传时间:2023-02-06
- 格式:DOCX
- 页数:10
- 大小:17.90KB
vb函数大全VBfunctionDaquanWord格式.docx
《vb函数大全VBfunctionDaquanWord格式.docx》由会员分享,可在线阅读,更多相关《vb函数大全VBfunctionDaquanWord格式.docx(10页珍藏版)》请在冰豆网上搜索。
longinteger"
(Long)type
P=CSng(X)convertsXtoasingleprecision(Single)type
P=CStr(X)convertstheXtoastring(String)type
P=Cvar(X)convertstheXtoavariant(Variant)type
P=CVErr(X)'
convertsXtoaErrorvalue
[paradigm]:
(1)CStr(13)+CStr(23)afterthevalueisconvertedintoastring,andisconnectedwith"
+"
number,andtheresultis:
1323
(2)CInt("
12"
)+12'
stringsareconvertedintointegersandthensummedupwith12.Results:
24
(3)P=CInt(True)'
theoutputis-1
"
Booleanandnumericconversionsshouldbenoted,BooleanvaluesareonlyTrueandFalse,inwhichTrueis-1inmemory,andFalseis0
(4)CBool(-0.001)'
theoutputisTrue
WhenthevalueisconvertedtoBoolean,thevalueequalto0willbeFalse,andthevaluenotequalto0willbeTrue.
2.Int(X),Fix(X):
taketheintegervalueofX
P=Int(X)'
takesthemaximumintegervalueof<
=X
P=Fix("
)takestheintegerpartofXandremovesthedecimaldirectly
(1)Int(-54.6)'
theresultis-55,takethemaximumintegerof<
=-54.6
(2)Fix(54.6)'
theresultis54,takeanintegerandremovethedecimaldirectly
(two)commonlyusedmathematicalfunctions
1.Abs(N)takesabsolutevalue
Example:
Abs(-3.5)results:
3.5
2.Cos(N)cosinefunction
Cos(0):
1
3.Exp(N)eistheexponentialfunctionatthebottom
Exp(3):
20.068
4.Log(N)thenaturallogarithmbasedone
Log(10):
2.3
5.Rnd[(N)]generatesrandomnumbers
Rndresult:
thenumberbetween0--1
6.Sin(N)sinefunction
Sin(0):
0
7.Sgn(N)signedfunction
Explanation:
taketheplussign.Y=Sgn(X)isbothX>
0andY=1;
X=0isY=0;
X<
0isY=;
-1
8.Sqr(N)squareroot
Sqr(9):
3
9.Tan(N)tangentfunction
Tan(0):
10.Atn(N)reversefunction
Atn(0):
[note]intrigonometricfunctions,expressedinradians.
(string)classfunctionofstring:
1.,ASC(X),Chr(X):
conversioncharacter,charactercode
P=Asc(X)returnsthecharactercodeofthefirstcharacterofstringX
P=Chr(X)returnscharactersequaltoXcharacters
(1)P=Chr(65);
'
outputcharacter'
A'
becausetheASCIIofAisequalto65
(2)P=Asc("
A"
)
Output65
2.Len(X):
calculatethelengthofthestringX
P=Len(X)
[instructions]:
Theemptystringlengthis0,andthespacecharacterisalsoacharacter.AChinesetextoccupies2Bytes,butisalso
countedasacharacter.
(1)makeX="
(emptystring)
TheoutputofLen(X)is0
(2)makeX="
ABCD"
TheoutputofLen(X)is4
(3)makeX=VBtutorial"
3.Mid(X)function:
readthestringXcharactersinthemiddle
P=Mid(X,n)
ReadbytheNcharacterofX,readallthecharactersbehind.
P=Mid(X,N,m)
ReadbytheNcharacterofX,readtheMcharactersbehind.
(1)X="
ABCDEFG"
P=Mid(X,5)
Theresultis:
"
P="
efg"
(2)X="
P=Mid(X,2,4)
TheresultisP="
BCDE"
4.Replace:
replacessomeofthestringinastringwithanother
string
P=Replace(X,S,R)
[explanation]:
replacethestringSinstringXwithstringR,
andthenreturn.
X=,VB,is,very,good"
P=Replace(X,good,nice)
Theoutputis:
P=,VB,is,very,nice"
5.StrReverse:
invertedstring
P=StrReverse(X)
ReturnsthestringaftertheXparameterisreversed
ABC"
Output:
P="
CBA"
6.,Ucase(X),Lcase(X):
convertEnglishletterstouppercaseandlowercase
P=Lcase(X)
ConvertuppercasecharactersfromXstringstolowercase
P=Ucase(X)
ConvertlowercaselettersfromXstringstouppercase."
[instructions]noothercharactersorChinesecharacterswillbeaffectedexceptEnglishletters.
(1)makeX=,VB,and,VC"
TheresultofLcase(X)is"
VB,and,VC"
andUcase(X)is"
VBANDVC"
7.InStrfunction:
findingstrings
P=InStr(X,Y)
LocatethepositionoftheYfromthefirstcharacteroftheX
P=InStr(n,X,Y)
FindthepositionoftheYfromtheXncharacter
(1)iftheYisfoundinX,thereturnvalueistheplacewherethefirstcharacteroftheYappearsinX.
(2)InStr(X,Y)isequivalenttoInStr(1,X,Y).
(3)ifthestringlength,orXisanemptystring,orYisnotfoundinX,0isreturned.
(4)ifYisanemptystring,returns0.
Datetimeclassfunction:
1.,Year(X),Month(X),Day(X):
takeoutyear,month,day
P=Year(X)
TakeoutthevalueoftheX"
year"
section
P=Month(X)
month"
P=Day(X)
day"
[description]:
YearreturnsinAD,andifXhasonlytimeandnodate,thedateis#1899/12/30#
2.,Hour,Minute,Secondfunction:
takeout,divide,orsecond
P=Hour(X)
Takethevalueofthe"
partofthe"
when"
P=Minute(X)
Takeoutthevalueofthe"
part
P=Second(X)
seconds"
[indicatesthatthereturnvalueof]:
Hourisbetween0---23
X=10:
34:
23
Q=Minute(X)
R=Second(X)
Outputresults:
P=10,Q=34,R=23
3.,DateSerialfunction:
mergeyear,month,date,becomedate
DateSerial(Y,M,D)
WhereYistheyear,Misthemonth,andDisthedate
(1)ifthevalueofMisgreaterthan12,themonthwillbe
extrapolatedfromDecembertoM-12months;
iflessthan1,themonthwillbeextrapolatedfromJanuaryto1-Mmonths.
(2)ifthedateDisgreaterthanthenumberofdaysinthatmonth,thedatefromthedateofthemonth,thenumberofD-monthslater;
iflessthan1,thenthedatefrom1daysforwardprojections1-Ddays.
P=DateSerial(2000,02,02)
TheresultisP=2000/02/02
4.TimeSerialfunction:
whenmerging,minutesandsecondsbecometime
P=TimeSerial(H,M,S)
Histhenumberofhours,Misminutes,andSisseconds
theprincipleofcalculationisthesameasthatofDateSerialabove
P=TimeSerial(6,32,45)
Theresultwas:
P=6:
32:
45
5.Date,Time,Nowfunction:
readthedateandtimeofthesystem
P=Date()
P=Time()
P=Now()
noneofthesethreefunctionshavearguments
Ifthecurrenttimeis19:
26onAugust29,2003evening,45seconds,then
P=2003-08-2919:
26:
6.MonthName:
returnsthenameofthemonth
P=MonthName(X)
[toindicatethatthe]:
Xparametercanbepassedinto1---12,returnsthevalueof"
and"
February"
......ButinEnglishWindows,thereturnis"
January"
"
......
P=MonthName
(1)
onemonth"
7.WeekdayName:
returnsthenameoftheweek
P=WeekdayName(X)
[showsthatthe]:
Xparametercanbepassedin1-7,andreturnsthevalue"
Sunday"
Monday"
......ButinEnglishwindows,thereturnis"
Monday"
P=WeekdayName
(1)
P=,Sunday"
MathematicalfunctionofVB.NETfunctionDaquan
Abs(Num)takesabsolutevalue.
Exp(Num)returnsthevalueofeatthebottomandnumasanexponent,suchasExp
(2)returningthee^2value.
Log(Num)returnsthenaturalpairvalueofparameternum,whichistheDoubletype,thatis,thelogarithmbasedonE.
Hex(Num)convertstheparameternumto16.
Oct(Num)convertstheparameternumto8
Sign(Num)returnsthepositiveandnegativesignoftheparameter.Ifnumisgreaterthan0,thereturnvalueis1;
ifnumequals0,thenthereturnvalueis0;
ifnumislessthan0,thenthereturnvalueis-1.
Sqrt(Num)returnsthesquarerootoftheargument,Doubletype.
Atan(Num)tangentfunction
Sin(Num)sinefunction
Cos(Num)cosinefunction
Tan(Num)tangentfunction
Rand(Num,[int])willentertheparameternumfour,five,tospecifyfourtofiveintowhichdecimal,youcanaddsecondparametersint.Forexample,Round(12.456)returnsthevalueof12
Round(12.4567,3)returns12.457.
Rnd[[nun]]producesarandomnumberlessthan1,greaterthanorequalto0,oftypeSingle.Ifnumislessthan0,theneachwillreturnthesamenumber;
ifyoudon'
tprovidetheparametersorparameterisgreaterthan0,soinordertogeneratearandomnumbernext,thisisthedefaultvalue;
iftheparameternumisequalto0,thenreturnsthelastgeneratedrandomnumber.Inordertogeneratedifferentrandomnumberseachtime,itisbettertousetheRandomizestatementbeforeusingtheRand()function.TorandomlygenerateanintegerfromNtoM,youcan
usethefollowing
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- vb 函数 大全 VBfunctionDaquan