ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   User Defined Function is not working for me in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/210810-user-defined-function-not-working-me-excel-2007-a.html)

Abdi

User Defined Function is not working for me in Excel 2007
 
Hi,
I've trying to practise VBA in Excel 2007. But when I enter the UDF I'm
getting #NAME? Anyone can help me where the problem is?
Regards
Abdi

Dave Peterson

User Defined Function is not working for me in Excel 2007
 
Did you allow macros to run when you opened the file that contained the code?

Did you put the UDF code in a general module--it doesn't belong in a worksheet
module or behind ThisWorkbook.



Abdi wrote:

Hi,
I've trying to practise VBA in Excel 2007. But when I enter the UDF I'm
getting #NAME? Anyone can help me where the problem is?
Regards
Abdi


--

Dave Peterson


All times are GMT +1. The time now is 11:57 PM.

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