How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9666
Experience:  Worked on Macs and PC's for 20+ years.
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

In MS Office 2004 for Mac, in Excel I want to write a user-defined

Resolved Question:

In MS Office 2004 for Mac, in Excel I want to write a user-defined function. I suppose I have to use VB. How do I write the function and how do I call it from a formula? Where can I find documentation for this? I don't know VB but I know fome other programming languages.
Submitted: 8 years ago.
Category: Mac
Expert:  John D replied 8 years ago.



Ok this is a file with a simple function to get cubic root of a number. The function is called cRoot().


So if you type =cRoot(A1) in any cell, it will display the cubic root of whatever value there is in cell A1.




To access the code, go to Tools > Macro > Visual Basic Editor


The simplified process of creating functions is fully described in this webpage:


Hope this helps. Let me know if you have any questions.


John D and other Mac Specialists are ready to help you