1,可以用“goto 行号” 语句跳出select
2,退出函数用Exit Function (或Exit Sub)
看看下面例子
新建窗体,添加2个命令按钮命名为Command1(0) 和Command1(1)
Option Explicit
Private Sub Command1_Click(Index As Integer)
Select Case Index
Case 0
GoTo QuitSelect
MsgBox "000"
Case Else
MsgBox "1"
End Select
QuitSelect:
Call abc
End Sub
Private Function abc()
MsgBox "abc"
Exit Function
MsgBox "abc 2"
End Function
示例如下
Private Sub Command2_Click()
ShowInfo "王"
ShowInfo "李"
ShowInfo "张"
ShowInfo "刘"
End Sub
Sub ShowInfo(strName As String)
Select Case strName
Case "王"
MsgBox strName & " 先生,您好!"
Case "李"
MsgBox strName & " 先生,您好!"
Case "张"
MsgBox strName & " 先生,您好!"
Case Else
MsgBox "不接待除王、李、张之外姓氏的客人!"
End Select
End Sub