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

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

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" <karelpostulart@planet.nl> wrote in message
news:4310a912$0$8786$ba620dc5@text.nova.planet.nl...
> Hi,
>
> Is there somewhere a complete list of standad available functions within
> Visual basic for Excel ?
>
> With regards,
>
> Karel Postulart
>
>

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" <twogilvy@msn.com> wrote in message
news:OHZnhOzqFHA.908@tk2msftngp13.phx.gbl...
> 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" <karelpostulart@planet.nl> wrote in message
> news:4310a912$0$8786$ba620dc5@text.nova.planet.nl...
> > Hi,
> >
> > Is there somewhere a complete list of standad available functions within
> > Visual basic for Excel ?
> >
> > With regards,
> >
> > Karel Postulart
> >
> >
>
>

I thank you for your answers. I know enough !

Regards,

Karel


"Tom Ogilvy" <twogilvy@msn.com> schreef in bericht
news:Oxr0tTzqFHA.1252@TK2MSFTNGP09.phx.gbl...
> 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" <twogilvy@msn.com> wrote in message
> news:OHZnhOzqFHA.908@tk2msftngp13.phx.gbl...
>> 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" <karelpostulart@planet.nl> wrote in message
>> news:4310a912$0$8786$ba620dc5@text.nova.planet.nl...
>> > Hi,
>> >
>> > Is there somewhere a complete list of standad available functions
>> > within
>> > Visual basic for Excel ?
>> >
>> > With regards,
>> >
>> > Karel Postulart
>> >
>> >
>>
>>
>
>