title: Any method equivalent to PadLeft/PadRight?
body: <p>Just wondering, is there any equivalent in VBA to VB .NET's PadLeft and PadRight methods?</p>
  
  <p>As of right now, whenever I want to take a string and make it a fixed length with leading spaces, I do a For...Next loop based on the string's length.</p>
  
  <p>For example, I would use the following code to format a string to 8 characters with leading spaces:</p>
  
  <pre><code>intOrdNoLen = Len(strOrdNo)
  For i = 1 To (8 - intOrdNoLen) Step 1
      strOrdNo = " " &amp; strOrdNo
  Next
  </code></pre>
  
  <p>Is there a way to do this same thing in fewer lines in VBA?</p>