title: Assign module function to ActiveX command button DIRECTLY
body: <p>In VBA for Excel, how do I assign an existing function or sub, say myFun(), in a module to a newly added ActiveX click button directly? </p>
  
  <p>I understand I can do the following on the worksheet code page where the ActiveX command (click) button is located.</p>
  
  <pre><code>Private Sub myFun_Click()
  myFun()
  End Sub
  </code></pre>
  
  <p>By "directly" I mean naming the button "myFun" and point the button directly to the function myFun() with having to placing myFun() in another sub as shown above.</p>