| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove Command Button After Click | Excel Discussion (Misc queries) | |||
| Command Button Click | Excel Discussion (Misc queries) | |||
| further options following a command button click | Excel Discussion (Misc queries) | |||
| Is there any way to have a maco click a command button | Excel Discussion (Misc queries) | |||
| Linking one worksheet to another by click on a command button | Excel Discussion (Misc queries) | |||
Linear Mode
