How do I set a macro to run when I click a Command Button in Exce.

G

Guest

I'm new to this whole Visual Basic macro-programming world however have
recorded and run macros in Excel 5.0 in the past with great success.

I have recorded a macro that creates a Chart in my workbook based on the
data that I select. I want to place a Command Button on the Data Input sheet
that will run this chart macro after the pertinent data-range has been
selected. How do I accomplish this task?
 
G

GMet

In the Click event of the command button put:
call MyChartMacro (or whatever name you have given to the macro that
makes the chart)

GMet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a Chart with a macro in 2007 4
How to call Excel add-in macro from a button… 1
Run a recorde macro in multiple excel workbook at a time 3
how to run a recorded macro in many files at a same time 1
Command button to run a macro 3
Macro hangs when run from a command button 11
Macro code for clicking on Command Button in another workbook 7
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16

Top