Solved

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

Posted on 2011-02-16
3
222 Views
Last Modified: 2012-05-11
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
Comment
Question by:eht9250
  • 2
3 Comments
 
LVL 23

Expert Comment

by:Michael74
ID: 34913162
why not just a button to the sheet and in the on click event call the required sub
0
 
LVL 23

Accepted Solution

by:
Michael74 earned 50 total points
ID: 34913189
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
 

Author Closing Comment

by:eht9250
ID: 34913469
I so much appreciate the quick response!  Makes all the difference.  Thank you.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now