I need code that will determine if a user defined function exists in a VBA project.
Assume that the workbook containing the project is already open and that the user defined function is named "Myfunction". I think the code probably should loop through the VBProject components somehow, identify the user defined functions, and if "Myfunction" is found, then do something, like display a message box.
I need this because I am adding the function by programmatically inserting code by ".bas" to files in a directory that may or may not already have the function defined. If it already exists in the file, the function is double defined and does not work.
Bookmarks