Conclunion
After you've written a few user-defined functions in VBA, you cannot help but notice that they do awful things to your calculation performance. Converting your VBA user-defined functions into C or C++ based XLLs will solve this performance problem. Well-written XLL functions exhibit calculation performance that is indistinguishable from native Excel worksheet functions. If you need user-defined functions and calculation speed is important, take the time to learn how to program XLLs. The results will be well worth the effort.
|
