ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   i cant see my user defined functions in function list (https://www.excelbanter.com/excel-worksheet-functions/104471-i-cant-see-my-user-defined-functions-function-list.html)

delmac

i cant see my user defined functions in function list
 
I've created a public function but cant use it because its not in the drop
down list of functions under user defined, am I missing something. thanks a
lot everyone
--
delmac

Bob Phillips

i cant see my user defined functions in function list
 
Did you create them in a standard code module, and not declare them Private,
and don't make the module Option Private?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"delmac" wrote in message
...
I've created a public function but cant use it because its not in the drop
down list of functions under user defined, am I missing something. thanks

a
lot everyone
--
delmac





All times are GMT +1. The time now is 04:41 PM.

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