View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NYExcel
 
Posts: n/a
Default How to create a New system function

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€ť)