Problem with Msgbox in VBA

[Puzzled Programmer]

I am trying to use a message box, but Excel won't accept a title




eg Msgbox("This is a test message",,"Test Message")

When I press Enter I get a message

Compile Error Expected: =

I am very puzzled.

It works correctly without a title eg
Msgbox("This is a test message")

Any thoughts........... and many thanks


Puzzled Programmer

[jeffreybrown]

Take off the parenthesis...

Sub MessageBox()
    MsgBox "This is a test message", , "This is a Message"
End Sub

Please use code tags when posting code

[Puzzled Programmer]

I have already tried that

For instance


Msgbox("This is a test message",,Test Message) produces an error


Compile error
Expected: List separator or )


still puzzled... but thanks for your swift response

[jeffreybrown]

Did you try exactly what I posted? I see you still have the parenthesis in your post #3.

[Puzzled Programmer]

Aha - sorry I misunderstood.


Eureka


Msgbox "This is a test message",,"Test message"


seems to work. Interesting, I have always included parentheses in Msgbox statements before, but as far as I remember this is the first time I have tried to put a title in as well.


Thanks for your help


Puzzled no longer

[jeffreybrown]

You are very welcome. Happy to help in some small way and happy Exceling.

[trevorc]

This line as is expects an input from the messagebox to be returned to a variable Msgbox("This is a test message",,"Test Message")

This should work... T = Msgbox("This is a test message",,"Test Message")