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, Nov 21 '13 at 05:41

score 2 · Accepted Answer · answered Nov 21 '13 at 04:46

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 '13 at 04:46

Craig T

1 Answers1