How to create a New system function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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â€)
 
It will be, in the User Defined category.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I creat 2
Use Numbers in Specific Cell 1
Pickup Data from a Worksheet 3
Produce Random Numbers 6
Illegal Instruction Thrown When Executing a Callback Function 5
Set non-continuous PrintArea via Function / Name 0
Looping for user input in a textbox 38
Getting Defined Name from Cell 7

Back
Top