Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Running a Macro automatically from Excel
I have a simple keystroke macro which runs the calculations on a worksheet 2
times based on an input parameter and posts the results to the main worksheet. My main worksheet contains all my inputs and my result fields. I would like to set it up so that when any of the inputs are changed on the main worksheet my macro is reran automatically so that the results are updated. Any suggestions. Dave |
#2
|
|||
|
|||
Use the Worksheet_Change() event to automatically run your macro. See
http://cpearson.com/excel/events.htm In article , Brakeshoe wrote: I have a simple keystroke macro which runs the calculations on a worksheet 2 times based on an input parameter and posts the results to the main worksheet. My main worksheet contains all my inputs and my result fields. I would like to set it up so that when any of the inputs are changed on the main worksheet my macro is reran automatically so that the results are updated. Any suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions | |||
How to stop Excel from automatically selecting cells? | Excel Discussion (Misc queries) | |||
automatically running a macro | Excel Discussion (Misc queries) | |||
Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) |