<div>
why not just a button to the sheet and in the on click event call the required sub
</div>


why not just a button to the sheet and in the on click event call the required sub

<div>
I so much appreciate the quick response! &nbsp;Makes all the difference. &nbsp;Thank you.
</div>


I so much appreciate the quick response!  Makes all the difference.  Thank you.

<div>
<div class="content wysiwyg-content">
I need to start a module running so I would like a front end for the user to start the code. &nbsp;I would like to create a simple userform and execute;<br />
Sub MainProcessing()<br />
&nbsp; &nbsp; Select_A_File<br />
&nbsp; &nbsp; GetMarData<br />
End Sub
</div>
</div>


I need to start a module running so I would like a front end for the user to start the code.  I would like to create a simple userform and execute;
Sub MainProcessing()
    Select_A_File
    GetMarData
End Sub

Run a sub from a click or toggle in a userform in Excel 2007

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.