Function Reference?

[Alan Little]

Is there a central function reference for Excel VBA, either in Help or
online, which lists all the functions available? I can look up a function
if I know the name of it, but I need to find out, for example, what string
functions are available (e.g. MID, TRIM, etc.) without having to guess.

I've tried everything I can think of, and can't find anything.

 

[Martin Seelhofer]

Hey Alan

Is there a central function reference for Excel VBA, either in Help or
online, which lists all the functions available? I can look up a function
if I know the name of it, but I need to find out, for example, what string
functions are available (e.g. MID, TRIM, etc.) without having to guess.

I've tried everything I can think of, and can't find anything.

The Object Browser might be what you are looking for: Simply press
F2 (or use the menu: View - Object Browser) in the Visual Basic Editor.


Cheers,
Martin

 

[Alan Little]

Carved in mystic runes upon the very living rock, the last words of
Martin Seelhofer of microsoft.public.office.developer.vba make plain:

Hey Alan


The Object Browser might be what you are looking for: Simply press
F2 (or use the menu: View - Object Browser) in the Visual Basic
Editor.

Yes, thank you. Specifically, the VBA library details the functions
available, with the different categories (DateTime, Math, String, etc.)
as objects. Right-clicking a function provides a link to Help.

Thanks for the pointer.

 

[Tushar Mehta]

You can also find all the VBA functions through the help file.

Help | Microsoft Visual Basic Help will bring up the Table of Contents.
Expand Microsoft Visual Basic Documentation | Visual Basic Language
Reference | Functions

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions