user3015968
user3015968

Reputation: 23

VBA msgbox error

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

Upvotes: 2

Views: 1765

Answers (1)

Craig T
Craig T

Reputation: 2742

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.

Upvotes: 2

Related Questions