VBA 101, line break in code but not the message

[LloydFinancials]

How do I insert a line break in the code but not the message for msgbox, meaning I only want 1 line in the message, just want to break the code up?

for example

MsgBox "Value in " & Sheets(s).Name & Cells(5, t).Address & " does not match the corresponding value in " & Sheets("Fields and Formulas").Cells(t, 13).Address & " in the tab 'Fields and Formulas.'"

 

[dmt32]

Hi,
Is this what you mean?

MsgBox "Value in " & Sheets(s).Name & Cells(5, t).Address & _
       " does not match the corresponding value in " & _
       Sheets("Fields and Formulas").Cells(t, 13).Address & _
       " in the tab 'Fields and Formulas.'"

Dave

 

[Joe4]

You add a space and an underscore, like this:

MsgBox "Value in " & Sheets(s).Name & Cells(5, t).Address & " does not match the corresponding value in " & _
    Sheets("Fields and Formulas").Cells(t, 13).Address & " in the tab 'Fields and Formulas.'"

 

[LloydFinancials]

thanks, solved

 

[dmt32]

Glad we were able to help & resolve
Feedback appreciated

Dave