Else without if vba



我是初学者。你能告诉我为什么我有这个错误吗:;否则没有IF";?

If ComboBox3.Value = "" Then FROM = ""
ElseIf ComboBox3.Value = "" Then FROM = ""
ElseIf ComboBox3.Value = "" Then FROM = ""
ElseIf ComboBox3.Value = "" Then FROM = ""
ElseIf ComboBox3.Value = "" Then FROM = ""
ElseIf ComboBox3.Value = "" Then FROM = ""
ElseIf ComboBox3.Value = "" Then FROM = ""
ElseIf ComboBox3.Value = "" Then FROM = ""
ElseIf ComboBox3.Value = "" Then FROM = ""
ElseIf ComboBox3.Value = "" Then FROM = ""
Else: FROM = ""
End If
Else: FROM = ""
'Notice the colon after the `Else`

编辑:第一个ElseIf的错误是由隐含关闭的If引起的。您必须转到Then之后的新行,否则If将被隐含地关闭。

'Fixed Code:
If ComboBox3.Value = "" Then
FROM = ""
ElseIf ComboBox3.Value = "" Then
FROM = ""
'Your code continue...
End If

最新更新