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

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

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

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

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