

图a
函数 IsLetter(x)功能,若 x 是字母,则返回值为字母 x 在字母序列“A”~“Z”中的序号,如字母“A”的序号为 0,字母“D”的序号为 3。若 x 不是字母,则返回值为-1。
Function IsLetter(x As String) As Integer
If ”A” <= x And x <= ”Z” Then
IsLetter = Asc(x) - Asc(”A”)
ElseIf ”a” <= x And x <= ”z” Then
IsLetter = Asc(x) - Asc(”a”)
Else
①
End If
End Function
Private Sub Command1_Click()
Dim f(25) As Integer, m As Integer, n As Integer
Dim s As String, c As String
List1.Clear
For m = 0 To 25 '初始化数组 f
f(m) = 0
Next m
s = Text1.Text
For m = 1 To Len(s)
c = Mid(s, m, 1) '依次读取字符串中的每个字符进行判断
②
If n <> -1 Then f(n) = f(n) + 1
Next m
For m = 0 To 25
If ③ Then '输出统计结果,没有出现的字母不输出
List1.AddItem(Chr(m + Asc(”a”)) & ”:” & f(m))
End If
Next m
End Sub
① ② ③
Private Sub Command1_Click()
Dim s1 As String,s2 As String,pos As Integer
Dim num As Integer
s1=Text1. Text:s2=“”
①
pos=2
Do While pos<=Len(s1)
If Mid(s1, pos, 1)=Mid(s1, pos-1, 1)Then
num=num+1
Else
s2= ②
num=1
End If
③
Loop
Text2. Text=s2+Str(num)+Mid(s1, Len(s1), 1)
End Sub
① ② ③
Private Sub Commandl_Click()
Dim n As Integer
n=Val(Text1.Text)
i=1
Do While ①
s=s+n\5^i
i=i+1
Loop
List1.AddItem Str(n)+"!末尾包含0的个数:"+ ②
End Sub
①②
Dim a( 1 To 100) As Integer
Dim n As Integer
Function dq(s As String, L As Integer) As String ‘自定义对齐函数
‘在输入的字符串s前加若干空格,输出长度为L的字符串,代码略
EndFunction
Private SubCommand1_Click() '生成数字矩阵
‘随机生成n^2个数字,存储在数组a中,代码略
‘以一行n个,共n行的格式显示在List 1中,代码略
End Sub
Private Sub Command2_Click() '数字矩阵排序
Dim i As Integer, k As Integer, j As Integer, s As String
Dim f As Boolean
List 2.Clear
f=True
For i=1 To n^2 Step n
s=“”
For j=i To
k=n^2
Do While ①
If a(k) <a(k-1) Then
t=a(k):a(k)=a(k-1):a(k-1)=t
End If
k=k-1
Loop
If f=True Then
s=s+“”+dq(Str(a(j) ) , 2)
Else
s=“”+dq(Str(a(j) ) , 2) +s
End If
Next j
List 2.Add Items
②
Next i
End Sub
① ②
Private sub cmd1_click( )
Dim b(1 to 10) as integer
Dim i as integer, max as integer, a as integer, c as integer
Max=0
For i=1 to 10
Randomize
A=int(rnd*99)+1
List1.additem str(a)
Next i
For i=2 to 10
C=
If c>max then
Next i
End sub
为实现上述功能,小王编写如下VB程序,首先在Text1中输入两个满足条件的序列,数字之间用“,”隔开且以“,”结尾,单击按钮“Cod1”,在Text2中输出最小值所在序列中的位置,程序运行界面如下图所示。
Private Sub Cod1_Click( )
Dim s As String, ch As String
Dim i As Integer, j As Integer, n As Integer, c As Integer
Dim a(100) As Integer
s = Text1.Text: c = 0: n = 0
For i = 1 To Len(s)
ch = Mid(s, i, 1)
If ch >= "0" And ch <= "9" Then
Else
n = n + 1
c = 0
End If
Next i
i = 1: j = n
Do While
m = (i + j) \ 2
If a(m) > a(i) Then
i = m
Else
j = m
End If
Loop
End Sub
①df. groupby('学校').mean( )
②df. groupby('数学').mean( )
③df. groupby('学校').数学.mean( )
④df. groupby('学校').describe( )

Const n = 10
Dim num(1 To n) As Integer, w(1 To n) As Integer
Private Sub Form_Load()
'本过程从数据库中读入n件物品的编号和重量分别存数组num,w中,并在List1中显示,代码略。
End Sub
Private Sub Command1_Click()
Dim i As Integer, j As Integer
Dim t As Integer, f As Boolean
Dim p As Integer, q As Integer
Dim k As Integer, flag As Boolean
f = False
i = 1
Do While ![]()
f = True
For j = n To i + 1 Step -1
If Then
t = num(j): num(j) = num(j - 1): num(j - 1) = t
t = w(j): w(j) = w(j - 1): w(j - 1) = t
f = False
End If
Next j
Loop
For i = 1 To n
List2.AddItem Str(num(i)) + " " + Str(w(i))
Next i
k = Val(Text1.Text)
flag = False
p = 1: q = n
Do While
If w(p) + w(q) < k Then
p = p + 1
ElseIf w(p) + w(q) > k Then
q = q - 1
Else
List3.AddItem Str(num(p)) + "和" + Str(num(q))
flag = True
p = p + 1: q = q - 1
End If
Loop
If Not flag Then
List3.AddItem "未找到这样的组合"
End If
End Sub
Private Sub Com_ Click()
Dimi As Integer, j As Integer, ans As Integer
Dim ch As String, s As String
s= Text1.Text
ans=0: j= 1
For i=1 To Len(s)
If ch=“,”Then
ans=ans+Val(Mid(s, j, i-j))
j=
End If
Next i
Label1.Caption=“计算结果是:”+Str( ans)
End Sub