ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   UserDefined Functions (https://www.excelbanter.com/excel-programming/325841-userdefined-functions.html)

ExcelMonkey[_190_]

UserDefined Functions
 
Is there a quick way in VBA to tell if a function used in
a cell formula is a userdefined function? That is, I know
I can load the Excel Functions into an array and then do a
match on the function found in the cell against the array
and check to see if it is in the array. If its not found
(iserror =true) its userdefined. But this means I have to
actually find funtions in formulas to do this? Is there
an easier way to spot userdefined functions in formulas?

Thanks




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

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