循环语句如下:For i = 1 To 6 strTmp = Mid(txt1, i, 1) ...... Next i
Private Function Comp(ByVal s As String) As Boolean Dim i As Integer Dim s1 As String If Len(s) <> 6 Then Comp = False: Exit Function For i = 1 To 6 s1 = Mid(s, i, 1) If s1 Like "[0-9,A-F]" Then Comp = True Else Comp = False Exit Function End If Next End FunctionPrivate Sub Form_Load() MsgBox Comp("124566") MsgBox Comp("43H456") End Sub
Public Function IsValidColor() As Boolean IsValidColor = True For i = 1 To 6 .... If Not (strTmp Like "[0-9,A-F,a-f]") Then IsValidColor = False Exit Function End If Next i End Function
Dim strTmp As String
strTmp = "g"
Select Case strTmp
Case "0" To "9", "A" To "F", "a" To "f"
Debug.Print "valid"
Case Else ' 无效值 '
Debug.Print "无效颜色值"
End Select
End Sub
strTmp = Mid(txt1, i, 1)
......
Next i
Private Function Comp(ByVal s As String) As Boolean
Dim i As Integer
Dim s1 As String
If Len(s) <> 6 Then Comp = False: Exit Function
For i = 1 To 6
s1 = Mid(s, i, 1)
If s1 Like "[0-9,A-F]" Then
Comp = True
Else
Comp = False
Exit Function
End If
Next
End FunctionPrivate Sub Form_Load()
MsgBox Comp("124566")
MsgBox Comp("43H456")
End Sub
IsValidColor = True
For i = 1 To 6
....
If Not (strTmp Like "[0-9,A-F,a-f]") Then
IsValidColor = False
Exit Function
End If
Next i
End Function