Line Break in VBA Code

Meldja Posted messages 343 Registration date Status Member Last intervention -
StartOof - 17 Mar 2016 at 12:25

Hello,
I have a line in a msgbox that is too long, and I don't remember how to go to the next line without it making a line break. I'm not sure if my question is clear.
Thank you in advance

Configuration: Windows XP Internet Explorer 6.0

4 answers

Answer 1 / 4

Best answer
The best answer is the one that has been validated by our teams.
eriiic Posted messages 24581 Registration date Status Contributor Last intervention 7 281

Ahhhhh.
the character _ (with a space before)
Otherwise, I do msg="blablabla" & vbcr
msg=msg & "blablabla"
msgbox(msg)
eric
9
1. Meldja Posted messages 343 Registration date Status Member Last intervention 33
  
  Ok, thank you very much.
  
  0
  1. rayane > Meldja Posted messages 343 Registration date Status Member Last intervention
    
    to return to the line, you need:
    blablabla _
    & blablabla _
    & blablabla
    
    0
Answer 2 / 4
eriiic Posted messages 24581 Registration date Status Contributor Last intervention 7 281

Good evening,

You split your string into several pieces that you join with vbCRLF
"string1" & vbcrlf & "string2"

eric
3
1. Meldja Posted messages 343 Registration date Status Member Last intervention 33
  
  Hi Eric, and thank you for your response.
  
  I certainly wasn't clear enough in my question. I don't want line breaks in the final result (that is, in my MsgBox), I just want to have line breaks in my code to have all the lines in front of me.
  
  The following code fits into one line:
  
  response = MsgBox("Are you sure you have finished filling out the form?" & vbCr & vbCr & "Click OK, this will cause the file to close and it will be saved on the desktop. " & vbCr & "You can then send it to me as an attachment and then you can delete it." & vbCr & vbCr & "Thank you", vbInformation + vbOKCancel, "BLABLA")
  
  I know there is a way to create line breaks in the code to have everything in front of me, but I forgot.
  
  Thanks again, and if you know the trick, I'd appreciate it.
  
  0
  1. Zyperman > Meldja Posted messages 343 Registration date Status Member Last intervention
    
    At the end of your line, you need to add a space and the character "_" you can then continue your code on the next line. ?
    
    0
Answer 3 / 4
Zyperman

At the end of your line, you must add a space and the underscore (from the 8 key). You can then continue your code on the next line.
1
1. eriiic Posted messages 24581 Registration date Status Contributor Last intervention 7 281
  
  6 years later and to say what has already been said...
  
  0
2. gorillo132
  
  ahah I admit, what a beta
  
  0
Answer 4 / 4
StartOof

MsgBox("Blablablablablablablablabla" & & _
"Blablablablabla" & & _
"Blabla", vbCritical, "ERROR")

(For example) it should work
0
1. StartOof
  
  You can also declare a String variable:
  
  Dim message As String
  
  message = "Blablablablabla"
  message = message & "blablablablabla"
  
  MsgBox(message, vbCritical, "ERROR")
  
  There you go :)
  
  0

Line Break in VBA Code

4 answers

The black swift flies for 10 months in a row without interruption

My pc won’t charge anymore and runs super slowly

Laptop: password forgotten

My second pc monitor

My computer stays connected for very little time

Unable to open xsl and xslx files

Pixma ts printer is broken

No internet connection possible

Print a page in the right orientation under windows 11

Change a contact’s ringtone