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.
53785
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.

Hi,

 

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.

 

FILE

 

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

 

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

 

http://www.fontstuff.com/VBA/vbatut01.htm

 

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

 

John D and 2 other Mac Specialists are ready to help you