7,784
社区成员




if (xxx)
if (yyy)
...
else
...
if (xxx)
if (yyy)
...
else
...
If xxx Then If yyy Then ... Else ...
Private Sub Command1_Click()
Text16 = Val(Text1.Text) + Val(Text4.Text) + Val(Text7.Text) + Val(Text10.Text)
Text17 = Val(Text2.Text) + Val(Text5.Text) + Val(Text8.Text) + Val(Text11.Text)
Text18 = Val(Text3.Text) + Val(Text6.Text) + Val(Text9.Text) + Val(Text12.Text)
dim anything as string
select case anything
case 条件1
Text8.Text = ""
Text9.Text = ""
Text16 = Val(Text16.Text) / 3
Text17 = Val(Text17.Text) / 3
Text18 = Val(Text18.Text) / 3
case 条件2
Text10.Text = ""
Text11.Text = ""
Text12.Text = ""
Text16 = Val(Text16.Text) / 3
Text17 = Val(Text17.Text) / 3
Text18 = Val(Text18.Text) / 3
case 条件3
Text16 = Val(Text16.Text) / 4
Text17 = Val(Text17.Text) / 4
Text18 = Val(Text18.Text) / 4
end select
End Sub
Private Sub Command1_Click()
Text16 = Val(Text1.Text) + Val(Text4.Text) + Val(Text7.Text) + Val(Text10.Text)
Text17 = Val(Text2.Text) + Val(Text5.Text) + Val(Text8.Text) + Val(Text11.Text)
Text18 = Val(Text3.Text) + Val(Text6.Text) + Val(Text9.Text) + Val(Text12.Text)
If Text7.Text = "" Then
Text8.Text = ""
Text9.Text = ""
Text16 = Val(Text16.Text) / 3
Text17 = Val(Text17.Text) / 3
Text18 = Val(Text18.Text) / 3
ElseIf XXXX Then 'XXXX为条件
Text10.Text = ""
Text11.Text = ""
Text12.Text = ""
Text16 = Val(Text16.Text) / 3
Text17 = Val(Text17.Text) / 3
Text18 = Val(Text18.Text) / 3
Else
Text16 = Val(Text16.Text) / 4
Text17 = Val(Text17.Text) / 4
Text18 = Val(Text18.Text) / 4
End If
End Sub