title: Excel Userform animated dots on loading
body: <p>There are a lot of tutorials in the Internet. However I was not able to find anything suitable. Is there any way to make animated dots on loading? </p>
  
  <p>The idea is to make a loop of animated dots <code>.....</code> on userform so they would appear one after another and then would start over after some amount of dots. </p>
  
  <p>So I input a dot to Label1 and move it to left after certain time criteria?</p>
  
  <p>My current code for UserForm:</p>
  
  <pre><code>    Private Sub UserForm_Initialize()
  HideTitleBar.HideTitleBar Me
      Call loadingdots
  End Sub
  </code></pre>
  
  <p>Code for <code>Private Sub Workbook_Open()</code>:</p>
  
  <pre><code>Loading.Show (vbModeless)
  
  Dim RngCom As Range
  Dim RngTurb As Range
  Dim RngGen As Range
  
  Application.Wait (Now + TimeValue("00:00:06"))
  
  ThisWorkbook.Worksheets("MAIN").ScrollArea = "$A$1:$BL$45"
      Application.DisplayFormulaBar = False
      ActiveWindow.DisplayHeadings = False
      ActiveWindow.DisplayGridlines = False
    etc...
    Unload Loading
  'Application.ScreenUpdating = True
    End Sub
  </code></pre>