title: calling a sub function with a button in vba
body: <p>I have 10  Sub function macros in "This workbook". Instead of running each macros, everytime i wanted an userform with button, and when I click , it should execute all the Sub function in "This workbook". </p>
  
  <p>I created another function like calling, and I used the following code, </p>
  
  <pre><code>Sub calling()
  
  
  Call lookup
  Call RangeTest
   Call datecompare
  Call AutoPivot
  Call Autochart
   Call pivot
  Call chart
  Call pivot1
  End Sub
  </code></pre>
  
  <p>so, whenever I go for macros, I select Sub calling() and it executes the 10 Sub functions. I would like to have it through a button click. Could anyone suggest how I can do this ? </p>