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 |
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. |
All times are GMT +1. The time now is 10:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com