I have been trying to find the answer to this in my dummies book but have not had too much success.
I'm writing a custom function in VBA. I want to use it in other Sub that is not in the same module where I wrote the function. When I tried to do this it gave me an error (I used the immediate window to check if it will work). I had to always click in the module where the function was in order to get it to work.
Is there a place I can put the function so that it will be recognized by all modules?
thx
I'm writing a custom function in VBA. I want to use it in other Sub that is not in the same module where I wrote the function. When I tried to do this it gave me an error (I used the immediate window to check if it will work). I had to always click in the module where the function was in order to get it to work.
Is there a place I can put the function so that it will be recognized by all modules?
thx