Problem with coding a msgbox

[Guest]

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

 

[Guest]

It expects you to assign it to something because it is in parenthesis.
Either say something like var = msgbox("whatever") or msgbox "whatever"

 

[Guest]

Thanks Kleev. Can you demo in my code, I understand your reply but am not
sure how to fix the VBA. Also any chance you could help insert the ((Chr 13)
in the correct place.

Thanks
Jacqui

 

[Gary Keramidas]

try this, i just set mycell to a value so i could get it to work, all you
need is the call msgbox line


Dim mycell As Range
Set mycell = Range("a1")
Call 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",
vbExclamation, "Change Request Form Error Checks")

 

[Carlos]

Hi Jacqui
try
dim your_msg as string

your_msg = "words"
MsgBox your_msg, vbInformation + vbOKOnly, "Change Request Form Error
Checks"

Carlos

 

[Jake Marx]

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]