Hi Jacqui,

First of all, get rid of the parenthesis, as you aren't retrieving the
return value, so you don't need them. Second, I would suggest using the
built-in MsgBox constants instead of 48, as it's more readable and easier to
make changes to in the future.

Here's a version that works for me:

MsgBox "You have not supplied all the relevant information for " & _
"this Segment type in Row " & myCell.Row & " on the Coding " & _
"Details Sheet." & vbLf & "PLEASE ENTER ALL DETAILS", vbExclamation _
Or vbOKOnly, "Change Request Form Error Checks"

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

Jacqui wrote:
This should be simple but somehow I can't get this right. Can anyone
help with the syntax below

Msgbox("You have not supplied all the relevant information for this
Segment type in Row " _ & myCell.Row & " on the Coding Details
Sheet - PLEASE ENTER ALL DETAILS" _
, 48, "Change Request Form Error Checks")

I'd like a vbexclamation style msgbox hence code 48 as style with an
OK only button and I'd also like to insert a title. I've coded
similar to this before without using all the Dim statements as in the
VB help but I can't get this to work without a Compile Error
Expected: =. Also where could I insert the ((Chr 13) command to
force a carraige return as my prompt message is quite lengthy. Can
anyone kindly help please?

Many thanks
Jacqui