VBA msgbox error

Question

my error is Compile error: expected =

msgbox (" Final Score:" & "P1score " & P1 & "P2score " & P2 & "P3score " & P3 & "P4score " & P4,vbOKOnly,"GameOver")

I was wondering how to fix this

you could just remove the brackets. MsgBox Join(Array("Final Score:", "P1score " & P1, "P2score " & P2, "P3score " & P3, "P4score " & P4), vbCrLf), vbOKOnly, "GameOver" — PatricK
– PatricK, Commented Nov 21, 2013 at 5:41

Craig T · Accepted Answer · 2013-11-21 04:46:56Z

2

MsgBox is a function which return a value (MSDN).

If you don't care about the return value then:

Call MsgBox(.....)

If you do care then:

returnValue = MsgBox(.....)

You may need to define 'returnValue' first.

answered Nov 21, 2013 at 4:46

Craig T

2,7725 gold badges25 silver badges34 bronze badges

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

1 Answer 1