software

How can I setup an function which I can view and use when I click “insert
function” or as a system?
e.g.
Public Function NewNumber(IDRange As Range)
NewNumber = IDRange.Cells(1, 1).Value 1
End Function
I want the function NewNumber can be as part the list functions when click
“insert function” (“fx”)

Place function in ageneral module and it will appear in the quot;User Definedquot;
category in the quot;Insert Functionquot; dialog.

quot;NYExcelquot; wrote:

gt; How can I setup an function which I can view and use when I click “insert
gt; function” or as a system?
gt; e.g.
gt; Public Function NewNumber(IDRange As Range)
gt; NewNumber = IDRange.Cells(1, 1).Value 1
gt; End Function
gt; I want the function NewNumber can be as part the list functions when click
gt; “insert function” (“fx”)

Thanks. But I want it as add in then I can use the function all the time with
attaching the code to all the workbook

quot;Toppersquot; wrote:

gt; Place function in ageneral module and it will appear in the quot;User Definedquot;
gt; category in the quot;Insert Functionquot; dialog.
gt;
gt; quot;NYExcelquot; wrote:
gt;
gt; gt; How can I setup an function which I can view and use when I click “insert
gt; gt; function” or as a system?
gt; gt; e.g.
gt; gt; Public Function NewNumber(IDRange As Range)
gt; gt; NewNumber = IDRange.Cells(1, 1).Value 1
gt; gt; End Function
gt; gt; I want the function NewNumber can be as part the list functions when click
gt; gt; “insert function” (“fx”)