excel functions in macros
 

How can VBA knows the scientific functions defined in Excel?
Is there a library to define all these functions in a VBA workbook?
Thank you

excel functions in macros
 

Have you looked in the Functions list, menu InsertFunction, these are
available to Excel

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Leopoldine" wrote in message
...
How can VBA knows the scientific functions defined in Excel?
Is there a library to define all these functions in a VBA workbook?
Thank you

excel functions in macros
 

If you are looking for code that implements the algorithms, that is not
available. Excel vba calls these functions same as you can call functions
in a dll. You don't need redundant code written in VB.

--
Regards,
Tom Ogilvy

"Leopoldine" wrote in message
...
How can VBA knows the scientific functions defined in Excel?
Is there a library to define all these functions in a VBA workbook?
Thank you

excel functions in macros
 

"Leopoldine" wrote:
How can VBA knows the scientific functions defined in Excel?
Is there a library to define all these functions in a VBA workbook?

If you would like to use an Excel spreadsheet function in VBA, use the
WorksheetFunction object.

WorksheetFunction.function(arg)

Note that not all worksheet functions are available this way. There's no
need to declare them or provide a reference, if that's what you were asking.
Or was there something else you wanted to do?