Forum Discussion
User Defined Function not showing with up "="
I have a few UDFs' that i have written for practice since i'm just getting into the programming portion of VBA. I have 3 Projects in my vba window. 1 for macros, 1 for my UDF, and the last one is wh...
Hi Katrina,
I'm sorry about that!
I forgot that this only works in the subroutines (Subs), not in the functions!
With regards to the functions, you need to create a new workbook and save the function in a module in this workbook, then you have to save this workbook as Excel Add-in (*.xlam) file extension.
After that, you need to copy this workbook into the XLSTART folder.
To locate this folder, please follow this path:
C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART
But please note that the code you attached seems to be wrong!
It's Option Explicit (Option without s).
Also, you have to remove the period (.) after the End Function!
Hope that helps
Your Post Saved Me Today!!! I fought with a user defined function for hours, could not get it to work just kept getting the "#NAME!" error.
Then, read your post and forgot to put it in the XLSTART folder.
Thanks!
Then, read your post and forgot to put it in the XLSTART folder.
Thanks!