VBE Help: How to get list of all string functions?

[joeu2004]

How can I get VBE Help to show me a list of all VBA string functions?

Because there is a function called "string", entering "string
functions" in the Search field does not seem to produce a link to a
complete list. Looking at the See Also list of some of the string
functions that come to mind also does not produce a link to a generic
list (surprise!).

I can keep stumbling around. But I would prefer to find a complete
list.

 

[Gary''s Student]

From VBA Help:

Contents > Visual Basic Conceptual Topics > Returning Strings from Functions

or

Contents > Visual Basic Language Reference > Functions - for all functions

 

[Chip Pearson]

You can use the Object Browser in VBA to do this. In the VBA editor, press
F2 to display the Object Browser. In the drop down box near the top of the
window, change "<All Libraries>" to "VBA" (not "VBAProject"). In the
"Classes" list, click on "Strings". This will list all the VBA functions
that Microsoft decided to put in the Strings class. When you click on an
item in the "Members" pane, the basic syntax of that function is displayed
at the bottom of the pane. Once you find a function that looks like what you
need, you can search for that member name in the Help files.

The Object Browser is one of the more powerful tools for VBA development.
You would do well to become familiar with it.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[joeu2004]

From VBA Help:
Contents > Visual Basic Conceptual Topics >
Returning Strings from Functions

Thanks. I probably should have mentioned that I am using Office Excel
2003 with VB 6.3.

Anyway, the list in "Returning Strings From Functions" is useful, but
it is not complete. For example, it fails to show the two functions,
which I found by stumbling around, that do exactly what I needed,
namely Split and Join.

I guess the answer is: VBA documentation does not provide any such
list (sigh).

or
Contents > Visual Basic Language Reference >
Functions - for all functions

Yes. But it is sorted alphabetically, not by category of operation
(i.e. string functions). It's a lot to scan without knowing what I'm
looking for. To be honest, I do not even remember how I stumbled upon
Split.

 

[joeu2004]

You can use the Object Browser in VBA to do this. In the VBA editor, press
F2 to display the Object Browser. In the drop down box near the top of the
window, change "<All Libraries>" to "VBA" (not "VBAProject"). In the
"Classes" list, click on "Strings".

Great! Thanks. Now, if I can only remember how to do this. The list
seems fairly complete, too -- at least Split and Join are there among
others.

Curious: what's the difference between Format and Format$, for
example. Is the latter more efficient because it is explictly typed?

 

[Chip Pearson]

The functions that end in '$' (e.g., String$) return String types. The
functions without the '$' return Variant types. The '$' functions are more
efficient.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

You can use the Object Browser in VBA to do this. In the VBA editor, press
F2 to display the Object Browser. In the drop down box near the top of the
window, change "<All Libraries>" to "VBA" (not "VBAProject"). In the
"Classes" list, click on "Strings".

Great! Thanks. Now, if I can only remember how to do this. The list
seems fairly complete, too -- at least Split and Join are there among
others.

Curious: what's the difference between Format and Format$, for
example. Is the latter more efficient because it is explictly typed?