title: Formatting text in messagebox excel Vba
body: <p>I am new to Excel VBA and have written Vba code to loop through cells and get their values.After that do some processing and if it matches a certain criteria append them to a list with line break.
  Do this until all rows are done. This works perfectly fine and end result is as image below:</p>
  
  <p><img src="https://i.stack.imgur.com/AdDbE.png" alt="enter image description here"></p>
  
  <p>The thing is i want the formatting to look neat , so is there a way that the gap in between the text is same on all rows so it looks neat.
  The way i add the rows is :</p>
  
  <pre><code>          Dim tmpLine
            tmpLine = line &amp; "      " &amp; dateVal
            mainMessage = mainMessage &amp; tmpLine &amp; vbNewLine
  </code></pre>
  
  <p>Not sure if its the perfect way but that is what i know...</p>