?
Solved

creating a button to run a macro in excel

Posted on 2007-04-10
3
Medium Priority
?
186 Views
Last Modified: 2013-12-25
I have an excel spreadseet that I am creating VB code for to run macros.  How do I create a button on the spreadsheet itself that will run the macro.
0
Comment
Question by:josephdaviskcrm
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 400 total points
ID: 18882376
Select View->Toolbars from the menu, choose the Forms toolbar, then select the button control from there.
HTH
Rory
0
 
LVL 13

Assisted Solution

by:nike_golf
nike_golf earned 300 total points
ID: 18882386
0
 
LVL 27

Assisted Solution

by:VBRocks
VBRocks earned 300 total points
ID: 18884048
Here's a really good link, if you want to actually add a button on the Spreadsheet itself:

http://www.mrexcel.com/tip068.shtml

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
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 demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

770 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