ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   User Defined Function does not appear on Function listing (https://www.excelbanter.com/excel-programming/356620-user-defined-function-does-not-appear-function-listing.html)

H.P.Hoeie, Norway

User Defined Function does not appear on Function listing
 
I've made two simple funtions, had no error messages. The functions are
restricted to the specific work sheet where they were made.
When I want to try them in a work sheet, they do not appear. Usually this
sequence works: Insert/Function/User Defined. But it does not appear there.



Niek Otten

User Defined Function does not appear on Function listing
 
You should put the functions in a standard module, not a sheet module

--
Kind regards,

Niek Otten

"H.P.Hoeie, Norway" wrote in message
...
I've made two simple funtions, had no error messages. The functions are
restricted to the specific work sheet where they were made.
When I want to try them in a work sheet, they do not appear. Usually this
sequence works: Insert/Function/User Defined. But it does not appear there.






All times are GMT +1. The time now is 02:17 PM.

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