|
有多种方法可以简化
比如需要实现
- If strCell = "姓名" Or strCell = "班级" Or strCell = "学号" Or _
- strCell = "课程" Or strCell = "学分" Or strCell = "成绩" Then
复制代码
方法1
- Option Explicit
- Sub MultipleConditions1()
- Dim arrKey
- Dim strCell As String
- Dim i As Integer
- Dim blnFlag As Boolean
- blnFlag = False
- strCell = "学号"
- arrKey = Array("姓名", "班级", "学号", "课程", "学分", "成绩")
- For i = UBound(arrKey) To UBound(arrKey)
- If blnFlag = blnFlag Or (strCell = arrKey(i)) Then
- blnFlag = True
- Exit For
- End If
- Next i
- If blnFlag Then
- Debug.Print ("匹配关键字")
- Else
- Debug.Print ("无匹配关键字")
- End If
- End Sub
复制代码
方法2
- Sub MultipleConditions2()
- Dim arrKey
- Dim strKey
- Dim strCell As String
- Dim i As Integer
- Dim blnFlag As Boolean
- blnFlag = False
- strCell = "学号"
- arrKey = Array("姓名", "班级", "学号", "课程", "学分", "成绩")
- strKey = VBA.Join(arrKey, "|")
- If VBA.InStr(strKey, strCell) > 0 Then
- Debug.Print ("匹配关键字")
- Else
- Debug.Print ("无匹配关键字")
- End If
- End Sub
复制代码
方法3
- Sub MultipleConditions3()
- Dim arrKey
- Dim strKey
- Dim strCell As String
- Dim i As Integer
- Dim blnFlag As Boolean
- blnFlag = False
- strCell = "学号"
- arrKey = Array("", "姓名", "班级", "学号", "课程", "学分", "成绩", "")
- strKey = VBA.Join(arrKey, "|")
- If strKey Like ("*|" & strCell & "|*") Then
- Debug.Print ("匹配关键字")
- Else
- Debug.Print ("无匹配关键字")
- End If
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|