Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Available functions within Excel VBA
Hi,
Is there somewhere a complete list of standad available functions within Visual basic for Excel ? With regards, Karel Postulart |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Available functions within Excel VBA
Open Help under Visual Basic and enter function as a keyword. I believe the
list is complete. More good news: most worksheet functions not directly available in VBA can be used anyway. For example ROMAN() to convert a number to Roman Numerals is not a VBA function, but you can still get to it with: TryString = Application.WorksheetFunction.Roman(35) Good Luck -- Gary's Student "ing. K.J.A. Postulart" wrote: Hi, Is there somewhere a complete list of standad available functions within Visual basic for Excel ? With regards, Karel Postulart |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Available functions within Excel VBA
See Ron de Bruin's site.
He is hosting Peter Nonely's function dictionary workbook: http://www.rondebruin.nl/id.htm the download link is at the bottom of that page. Other information on the page may be of interest as well. -- Regards, Tom Ogilvy "ing. K.J.A. Postulart" wrote in message . .. Hi, Is there somewhere a complete list of standad available functions within Visual basic for Excel ? With regards, Karel Postulart |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Available functions within Excel VBA
Sorry, I misread your question.
The list of VBA functions is in the Excel VBA help file. Go into the contents section of the help file. You can also look at the Object browse. For worksheetfunctions from Excel which can be used in VBA, see the Object browser for the WorksheetFunction class. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... See Ron de Bruin's site. He is hosting Peter Nonely's function dictionary workbook: http://www.rondebruin.nl/id.htm the download link is at the bottom of that page. Other information on the page may be of interest as well. -- Regards, Tom Ogilvy "ing. K.J.A. Postulart" wrote in message . .. Hi, Is there somewhere a complete list of standad available functions within Visual basic for Excel ? With regards, Karel Postulart |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Available functions within Excel VBA
I thank you for your answers. I know enough !
Regards, Karel "Tom Ogilvy" schreef in bericht ... Sorry, I misread your question. The list of VBA functions is in the Excel VBA help file. Go into the contents section of the help file. You can also look at the Object browse. For worksheetfunctions from Excel which can be used in VBA, see the Object browser for the WorksheetFunction class. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... See Ron de Bruin's site. He is hosting Peter Nonely's function dictionary workbook: http://www.rondebruin.nl/id.htm the download link is at the bottom of that page. Other information on the page may be of interest as well. -- Regards, Tom Ogilvy "ing. K.J.A. Postulart" wrote in message . .. Hi, Is there somewhere a complete list of standad available functions within Visual basic for Excel ? With regards, Karel Postulart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple functions, conditional functions | Excel Worksheet Functions | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
excel functions and User defined functions | Excel Programming |