How can I creat

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 "User Defined"
category in the "Insert Function" dialog.

"NYExcel" wrote:

> 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”)

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

"Toppers" wrote:

> Place function in ageneral module and it will appear in the "User Defined"
> category in the "Insert Function" dialog.
>
> "NYExcel" wrote:
>
> > 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”)