Thread: Error Box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Error Box

Dim strMsg As String

strMsg = "This is a message box" & vbLf
strMsg = strMsg & "text which is to be" & vbLf
strMsg = strMsg & "shown in three lines"

MsgBox strMsg, vbInformation, "Error"

If this post helps click Yes
---------------
Jacob Skaria


"Gazz_85" wrote:

I have an error box with quite a long error message. How in the code would i
get it to split the message up and stick it on other lines in order to
squeeze the box down??

Cheers