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

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?

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

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
"thewizrd" wrote in message
...
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?