ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sun a macro when a cell is calculated (https://www.excelbanter.com/excel-programming/413637-sun-macro-when-cell-calculated.html)

pontitt

Sun a macro when a cell is calculated
 
Hi All,

can you please help, how can Excel run automatically a function, when a cell
is calculated, even is this is autmatic calculation?

I mean, is here any event like:
App_CellCalculate?

Thanks

Tom Ogilvy

Sun a macro when a cell is calculated
 
No, there is no event associated with the calculation of an individual cell.
The calculation event occurs when a calculation occurs, but it is not
related to a specific cell nor does it identify which cells are calculated.

--
Regards,
Tom Ogilvy


"pontitt" wrote:

Hi All,

can you please help, how can Excel run automatically a function, when a cell
is calculated, even is this is autmatic calculation?

I mean, is here any event like:
App_CellCalculate?

Thanks



All times are GMT +1. The time now is 02:12 PM.

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