.1.輸入3個數(shù)，輸出最大的數(shù)Private Sub Command11_Click()Dim max%X1=Val(InputBox(input)X2=Val(InputBox(input)x3=Val(InputBox(input)max=X1If max=X2 Thenmax=X2End IfIf max=x3 Thenmax=x3End IfMsgBox(3個數(shù)之中的最大數(shù)max=&max)End SubPrivate Sub Command12_Click()2.有一元二次方程：aX2+bX+c=0，依次輸入a，b，c，判斷此方程是否有實根a=Val(InputBox(input)B=Val(InputBox(input)c=Val(InputBox(input)s=B2-4*a*cIf a0 ThenIf s=0 ThenMsgBox(兩個相等實根)ElseIf s0 ThenMsgBox(兩個不相等實根)ElseIf s=60 ThenMsgBox(恭喜！成績通過！)ElseMsgBox(抱歉！成績沒有通過！)End IfEnd SubPrivate Sub Command14_Click()4.輸入一年份，判斷它是否為閏年，并顯示有關(guān)信息。（判斷閏年的條件是：年份能被4整除但不能被100整除，或者能被400整除）yes=Val(InputBox(year)If yes Mod 4=0 And yes Mod 1000 Or yes Mod 400=0 ThenMsgBox(yes&是閏年)ElseMsgBox(yes&不是閏年)End IfEnd SubPrivate Sub Command15_Click()5.輸入學(xué)生的百分制成績，轉(zhuǎn)換輸出為五級制成績，90100分轉(zhuǎn)換為優(yōu)秀，8089轉(zhuǎn)換為良好，7079轉(zhuǎn)換為中等，6069轉(zhuǎn)換為及格，060轉(zhuǎn)換為不及格。score=Val(InputBox(input)Select Case scoreCase Is=90MsgBox(優(yōu)秀)Case Is=80MsgBox(良好)Case Is=70MsgBox(中)Case Is=60MsgBox(及格)Case ElseMsgBox(不及格)End SelectEnd Sub6.隨機產(chǎn)生一個三位正整數(shù)，然后逆序輸出，產(chǎn)生的數(shù)與逆序數(shù)同時顯示。例如，產(chǎn)生246，輸出是642。a=645n=Len(a)For i=1 To Int(n/2)c=Mid(a,i,1)Mid(a,i,1)=Mid(a,n-i+1,1)Mid(a,n-i+1,1)=cNext iMsgBox(a)End Sub7.輸入兩個整數(shù)，求它們的最大公約數(shù)m=Val(InputBox(input m值)n=Val(InputBox(input n值)If nm Thent=nn=mm=tEnd Ifr=m Mod nDo While r0m=nn=rr=m Mod nLoopMsgBox(最大公約數(shù)=&n)End Sub21.隨機產(chǎn)生10個30,100內(nèi)的整數(shù)，求最小值及所對應(yīng)的下標。Dim a(10)As IntegerFor i=0 To 9a(i)=Int(Rnd*70+30)Next imin=a(0)Mini=0For i=1 To 9If a(i)=max Thenmax=a(i)Elsemin=a(i)End Ifsum=sum+a(i)Next iMsgBox(max=&max)MsgBox(min=&min)MsgBox(avg=&sum/10)End SubPrivate Sub Command2_Click()8.編程求200-400范圍內(nèi)5的倍數(shù)或7的倍數(shù)之和。(一個數(shù)如果同時是7和5的倍數(shù)，則只能加一次。Dim sum1%,sum2%sum1=0:sum2=0For i=200 To 400If i Mod 5=0 Thensum1=sum1+iElseIf i Mod 7=0 Thensum2=sun2+iEnd IfDebug.Print i,sum1,sum2Next iMsgBox(5的倍數(shù)之和sum=&sum1)MsgBox(7的倍數(shù)之和sum=&sum2)End SubPrivate Sub Command20_Click()17.編程求斐波那契數(shù)列前11項。（斐波那契數(shù)列：F(0)=f(1)=1,F(n)=F(n-1)+F(n-2)n=2）Dim f(11)As Integerf(0)=1f(1)=1For i=2 To 10f(i)=f(i-1)+f(i-2)Next iFor i=0 To 10Print f(i);Next iEnd SubPrivate Sub Command21_Click()18.將輸入的字符串以反序顯示。例如：輸入ASDFGT，顯示TGFDSADim s(10)As StringFor i=0 To 9s(i)=InputBox(input)Next iFor i=9 To 0 Step-1Print s(i)Next iEnd SubPrivate Sub Command22_Click()19.隨機產(chǎn)生10個30,100內(nèi)的整數(shù)，求最大值及所對應(yīng)的下標Dim a(10)As Integer,max%For i=0 To 9a(i)=Int(Rnd*70+30)Next imax=a(0)maxi=0For i=1 To 9If a(i)=max Thenmax=a(i)maxi=iEnd IfNext iMsgBox(max=&max)MsgBox(maxi=&maxi)End SubPrivate Sub Command23_Click()20.隨機產(chǎn)生10個30,100內(nèi)的整數(shù)，求最大值、最小值和平均值。Dim a(10)As Integer,max%,min%For i=0 To 9a(i)=Int(Rnd*70+30)Next imax=a(0)min=a(0)For i=1 To 9If a(i)=max Thenmax=a(i)Elsemin=a(i)End Ifsum=sum+a(i)Next iMsgBox(max=&max)MsgBox(min=&min)MsgBox(avg=&sum/10)End SubPrivate Sub Command24_Click()24.利用隨機函數(shù)生成一個44的矩陣(即二維矩陣),范圍是20,50內(nèi)的整數(shù),輸出該矩陣所有數(shù)據(jù)之和Dim a(4,4)As IntegerDim sum%,i%,j%For i=0 To 3For j=0 To 3a(i,j)=Int(Rnd*30+20)sum=sum+a(i,j)Next jNext iFor i=0 To 3For j=0 To 3Print a(i,j),Next jPrintNext iMsgBox(sum=&sum)End SubPrivate Sub Command25_Click()25.已知有序數(shù)組a()，編程插入x（x的值為14）。數(shù)組a中的元素分別為12，6，4，89，75，63，100，20，31。Dim a(),iMin%,n%,i%,j%,t%a=Array(2,6,4,89,75,63,100,20,31)X=14n=UBound(a)獲得數(shù)組的下標上界For i=0 To n-1進行n-1輪比較iMin=i對第i輪比較時，初始假定第i個元素最小For j=i+1 To n在數(shù)組i+1n個元素中選最小元素的下標If a(j)a(iMin)Then iMin=jNext jt=a(i)i+1n個元素中選出的最小元素與第i個元素交換a(i)=a(iMin)a(iMin)=tNext iFor k=0 To n查找欲插入數(shù)x在數(shù)組中的位置If Xa(k)Then Exit ForNext kReDim Preserve a(n+1)數(shù)組增加一個元素For i=n To k Step-1數(shù)組元素后移一位，騰出位置a(i+1)=a(i)Next ia(k)=XFor i=0 To n+1Print a(i);NextEnd SubPrivate Sub Command26_Click()26.編寫一函數(shù)，計算Double類型一維數(shù)組所有元素的平均值。Dim a(),n%,s!a=Array(1,4,7,9,12,23,56)n=UBound(a)s=sum1(a()MsgBox(sum=&s)MsgBox(avg=&s/n)End SubFunction sum1%(X()Dim i%sum1=0For i=0 To UBound(X)sum1=sum1+X(i)Next iEnd FunctionPrivate Sub Command27_Click()27.用函數(shù)過程求表達式1+1/2+1/3+1/4+1/n的和.n=InputBox(INPUT)s=sum2(n)MsgBox(SUM2=&s)End SubFunction sum2!(ByVal n As Integer)Dim i%sum2=0For i=1 To nsum2=sum2+1/iNext iEnd FunctionPrivate Sub Command28_Click()28.編一子過程ProcMin,求一維數(shù)組a中的最小值，子過程的形參自己確定Dim a(),n%,min%a=Array(1,4,7,9,12,-23,56)n=UBound(a)Call procmin(a(),min)MsgBox(min=&min)End SubSub procmin(X(),ByRef min%)Dim i%min=X(0)For i=1 To UBound(X)If X(i)max Then max=X(i)Next iEnd FunctionPrivate Sub Command3_Click()9.計算100300之間所有能被3和7整除的數(shù)之和Dim sum%sum=0For i=100 To 300If i Mod 3=0 And i Mod 7=0 Thensum=sum+iPrivate Sub Command30_Click()30.編寫一個過程計算并輸出區(qū)間100，1000內(nèi)所有素數(shù)的和(要求判斷素數(shù)使用過程（函數(shù)或子過程）來實現(xiàn)。調(diào)用該過程。(提示：只能被1和自身整除的自然數(shù)稱為素數(shù)。)Dim i%,sum!,f%sum=0For i=100 To 1000Call procs(i,f)If f=1 Thensum=sum+iEnd IfNext iMsgBox(sum=&sum)End SubSub procs(ByVal X%,ByRef f%)Dim i%f=1For i=2 To X-1If i Mod X=0 Thenf=0Exit ForEnd IfNext iEnd SubPrivate Sub Command4_Click()10.分別統(tǒng)計1-100中，滿足3的倍數(shù)、7的倍數(shù)的數(shù)各有多少m=0:n=0For i=1 To 100If i Mod 3=0 Thenn=n+1ElseIf i Mod 7=0 Thenm=m+1End IfNext iMsgBox(3的倍數(shù)個數(shù)=&n)MsgBox(7的倍數(shù)個數(shù)=&m)End SubPrivate Sub Command5_Click()11.某次歌曲大獎賽，有7個評委。如果分別輸入7個評委對某個參賽者的打分數(shù)，按照去掉一個最高分和一個最低分的計算辦法，求出該參賽者的平均得分Dim sum%,max%,min%sum=0:max=0:min=999For i=1 To 7X=Val(InputBox(input)If max=X Thenmin=XEnd Ifsum=sum+XNext iAvg=(sum-max-min)/5MsgBox(最高分=&max)MsgBox(最低分=&min)MsgBox(總和=&sum)MsgBox(平均分=&Avg)End Sub12.輸入一串字符，統(tǒng)計其中字母A(不區(qū)分大小寫)出現(xiàn)的次數(shù)。Dim ch As Stringch=ASDEASn=0For i=1 To Len(ch)st=Mid(ch,i,1)If UCase(st)=AThenn=n+1End IfNext iMsgBox(字符串中出現(xiàn)A字符的系數(shù)&n)End SubPrivate Sub Command6_Click()13.我國目前有13億人口，按人口年增長率0.8%計算，多少年后我國人口將超過26億。n=0X=13Do While X=26X=X*1.008n=n+1LoopMsgBox(n)End SubPrivate Sub Command7_Click()14.小猴有桃若干，第一天吃掉一半多一個；第二天吃剩下桃子的一半多一個；以后每天都吃尚存桃子的一半多一個，到第7天只剩一個，問小猴原有桃多少？X=1For i=6 To 1 Step-1X=(X+1)*2Next iMsgBox(X)End SubPrivate Sub Command8_Click()15.求100以內(nèi)的