In our earlier post we showed one example of User Defined Function or Custom function that one can write to perform operations that are not provided by in build functions in the excel. Though there is one limitation of User Defined Function that the formula will not automatically recalculate the values whenever the cells are updated.
There is one way to overcome this limitation and that is to use Application.Volatile in the beginning of the Macro function. This will ensure that whenever any cell is updated in the sheet the function is recalculated.
Using Application.Volatile has further limitation. It makes the excel sheet a bit slow, this is because whenever you work on the sheet that has volatile User Defined Functions then the formula is recalculated. It's not a major lag though, much like other computer applications such as Open Office and free poker standalone games, it hardly affects your computer's processing power.
You can avoid using Application.Volatile if you are not doing any changes in the sheet.