How to make function to call only when input parameters are change

I'm creating set of user defined functions, but I only need to recall these function if and only a input par开发者_如何学运维ameter of a partcular function is change.

Currently, even I delete/insert a row the function are being called, How can I stop this function recalling ?

Thank You

Well, you can work around it by remembering the parameters that were passed to your function. You can use some global variable (an array) where you record the parameters. However, it does not sound very efficient.

Save the parameter(s) to Static variable(s) and exit the sub if the parameters haven't changed.