Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Macro does not function inside a list control | Excel Programming | |||
HELP NEEDED FOR IF Function Inside a Macro | Excel Worksheet Functions | |||
Nesting Networkdays function inside and If function | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions |