What's wrong with this snippet of VBA code?

Question

 If TextBox1.Text = "" Or TextBox1.Text = "False" Then
        msgbox("Filename invalid. Try again.",vbOKOnly)

I'm getting "Compiler Error: Expected: =" error message.

@jordanm: No. Visual Basic is sane and the correct comparison operator is = ;) — Ry-
– Ry- ♦, Commented Apr 15, 2012 at 2:48
@jordanm: Pretty sure it's =. == is used in C++ variant languages if I recall correctly. — stanigator
– stanigator, Commented Apr 15, 2012 at 2:48

Ry- · Accepted Answer · 2017-10-05 03:35:25Z

19

It's because you can only call Subs either with Call or without parentheses in VBA. So change it to:

MsgBox "Filename invalid. Try again.", vbOKOnly

Or, if you like this style better:

Call MsgBox("Filename invalid. Try again.", vbOKOnly)

(And the reason you get the error is because it expects you to assign the result to a variable, hence it expects an =.)

answered Apr 15, 2012 at 2:50

Ry-♦

226k56 gold badges496 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1