Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide a macros/functions from excel sheets | Excel Discussion (Misc queries) | |||
Excel Functions and Macros | Excel Discussion (Misc queries) | |||
Shortcut keys assigned to macros/functions in excel | Excel Worksheet Functions | |||
Can I call my .Net functions from Excel Macros | Excel Programming | |||
Excel: Deleting Macros and Functions | Excel Programming |