ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Error Box (https://www.excelbanter.com/excel-discussion-misc-queries/241936-error-box.html)

Gazz_85[_2_]

Error Box
 
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

Kevin Smith[_2_]

Error Box
 
Hello,

i use vbcr like..

MsgBox "First Line" & vbCr & _
"Second Line" & vbCr & _
"Third Line ", vbInformation, "Error"
--
Kevin Smith :o)


"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


Jacob Skaria

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



All times are GMT +1. The time now is 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com