VBA中出現ELSE 沒有IF怎麽辦?
有ELSE的時候,前面的THEN後面要單獨壹句,例如:\x0d\If x > y Then\x0d\ a = x And x = y And y = a\x0d\ElseIf y > z Then a = y And y = z And z = a\x0d\ElseIf x > y Then a = x And x = y And y = a\x0d\txt4.Value = z\x0d\txt5.Value = y\x0d\txt6.Value = x\x0d\End If