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

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
eht9250Asked:
Who is Participating?
 
Michael FowlerConnect With a Mentor Solutions ConsultantCommented:
More complete answer now I am back at my desk

To add a button to you workbook
http://office.microsoft.com/en-us/excel-help/add-a-button-and-assign-a-macro-to-it-in-a-worksheet-HP010236676.aspx

You can also assign a shortcut key to the macro

http://www.lytebyte.com/2008/10/06/how-to-create-custom-keyboard-shortcuts-in-excel-2007/

Michael
0
 
Michael FowlerSolutions ConsultantCommented:
why not just a button to the sheet and in the on click event call the required sub
0
 
eht9250Author Commented:
I so much appreciate the quick response!  Makes all the difference.  Thank you.
0
All Courses

From novice to tech pro — start learning today.