title: "Include" in Excel VBA?
body: <p>I have a user-form which is made up of many subs, this is assigned as a macro to a button on the worksheet. When the user is finished with this user-form they can press a button on it which causes its visibility to become false and when entered again everything appears how it was left resulting in a save like feature.</p>
  
  <p>I now need to apply this to multiple buttons on the worksheet and each user form needs to have the exact same code and same buttons but be a separate form as each individual button requires it's own save like feature. The way I was planning on doing this was to copy the existing user form and paste it many times with different names however, if a modification is required it will take a long time to carry out therefore, is there a method such as "include" which could use a base module from which all the code is accessed so that if I ever need to change anything I just do it on that one module and everything else updates via the include?</p>
  
  <p>EDIT:</p>
  
  <p>I now have a public function called costing() and am getting an error when I used:</p>
  
  <pre><code>Private Sub material_Change()
  Call costing
  End Sub
  </code></pre>