ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   run a macro inside of a function (https://www.excelbanter.com/excel-programming/377374-run-macro-inside-function.html)

A.Niaki

run a macro inside of a function
 
I want to run instantly a macro when value of a cell is changed (the value of
this cell is being control by a user function). It means €œIs it possible run
a macro inside of a function?€

Niek Otten

run a macro inside of a function
 
You can run a macro in a function, but it will not be able to change anything in the Excel environment so its use is limited. This
restriction is only if the function is called from a worksheet formula, directly or indirectly.
Look at Event Procedures:

http://www.cpearson.com/excel/events.htm


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"A.Niaki" wrote in message ...
|I want to run instantly a macro when value of a cell is changed (the value of
| this cell is being control by a user function). It means "Is it possible run
| a macro inside of a function?"




All times are GMT +1. The time now is 10:42 AM.

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