• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

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
0
eht9250
Asked:
eht9250
  • 2
1 Solution
 
Michael FowlerSolutions ConsultantCommented:
why not just a button to the sheet and in the on click event call the required sub
0
 
Michael FowlerSolutions 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
 
eht9250Author Commented:
I so much appreciate the quick response!  Makes all the difference.  Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now