Problem with coding a msgbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
It expects you to assign it to something because it is in parenthesis.
Either say something like var = msgbox("whatever") or msgbox "whatever"
 
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
 
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")
 
Hi Jacqui
try
dim your_msg as string

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

Carlos
 
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]
 
Back
Top