ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Constantly Run a Macro (https://www.excelbanter.com/excel-programming/278125-constantly-run-macro.html)

Stu[_5_]

Constantly Run a Macro
 
Is it possible to have a macro that is constntly running, so when
something is changed in the spreadsheet the macro updates so the macro
doen't have to keep being ran?

Thank you



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/


Ron de Bruin

Constantly Run a Macro
 
Read this webpage Stu about Events
I think this is what you need??
http://www.cpearson.com/excel/events.htm

Look for the Change Event


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Stu" wrote in message ...
Is it possible to have a macro that is constntly running, so when
something is changed in the spreadsheet the macro updates so the macro
doen't have to keep being ran?

Thank you



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/





All times are GMT +1. The time now is 10:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com