Correct syntax for msgbox

[ipbr21054]

Hi,
With the sytax below i keep getting a error.
It did have vbInformation but i removed it & now error is shown.
Whats the correct way for text,OK button & message title.

 MsgBox "CONTINUE TO NOW HYPERLINK CUSTOMER & PHOTO ?", "HYPERLINK PHOTO MESSAGE"

 

[Joe4]

You are missing the "Buttons" argument between the "Prompt" and "Title".
See: MsgBox function (Visual Basic for Applications)
(note: ALL these VBA functions are documented on-line and can be found with a simple Google search).

Since it is an optional argument, just add another comma to account for it, i.e.

 MsgBox "CONTINUE TO NOW HYPERLINK CUSTOMER & PHOTO ?",,"HYPERLINK PHOTO MESSAGE"

 

[ipbr21054]

Did a google search but didnt spot part about the comma

Now working thanks

 

[Joe4]

Did a google search but didnt spot part about the comma

Now working thanks

You are welcome.

It is just a matter of understanding what the various different arguments for the function are. The have to appear in the designated order, and are separated by commas. So if you have an "optional" argument, you can just leave it blank by having nothing between those two commas.

So in the link I provided you, it shows the arguments needed and their order:

As you can see, the first argument is "prompt" and it is required.
The "title" argument is the third and is optional.
So if you want to include both "prompt" and "title", you need to have at least 3 arguments, which means you need to have a value for the 2nd argument as well.
The second argument, "buttons", is also optional. So you can just leave it blank.

So in your case:

MsgBox prompt, buttons, title

can just be written like:

MsgBox prompt,,title

Since button is optional, you don't need a value for it, but you still need the comma as the placeholder so the "title" is still the 3rd argument.
Make sense?