List of VBA Functions and Constants

[Guest]

Hi

Does anyone know where/how I can find a comprehensive listing of Excel's VBA built-in functions (eg. Array(), UCase(), IsEmpty()) and constants (eg. vbnullstring, vbRed), either somewhere in Excel Help or a webpage

I am using Excel 2000 / VBA 6

Many Thanks

SuperJas.

 

[Rob Bovey]

Open the Visual Basic Editor and press F2 to display the Object Browser.
In the dropdown in the upper left corner of the Object Browser select VBA
from the list. The Object Browser will now display a list of everything
provided by VBA.

If you select an item you will get a short explanation in the bottom
pane. For more information, press F1 to bring up the help topic for the
selected item.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

Hi,

Does anyone know where/how I can find a comprehensive listing of Excel's

VBA built-in functions (eg. Array(), UCase(), IsEmpty()) and constants (eg.
vbnullstring, vbRed), either somewhere in Excel Help or a webpage?

 

[AA]

Open the Visual Basic Editor and press F2 to display the Object Browser.

In the dropdown in the upper left corner of the Object Browser select VBA
from the list. The Object Browser will now display a list of everything
provided by VBA.

If you select an item you will get a short explanation in the bottom
pane. For more information, press F1 to bring up the help topic for the
selected item.

Is there anyplace that describes the differences in the little icons for
the objects listed?

 

[Rob Bovey]

Is there anyplace that describes the differences in the little icons for
the objects listed?

I don't know of any right off the bat, but when you click on an item in
one of the lists, the description in the bottom pane tells you what type of
thing it is. Module, Class, Sub, Function, Property, Enum, Const, etc.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[AA]

Is there anyplace that describes the differences in the little icons for

I don't know of any right off the bat, but when you click on an item in
one of the lists, the description in the bottom pane tells you what type of
thing it is. Module, Class, Sub, Function, Property, Enum, Const, etc.

That does it, thanks.

Not that I know what all those things are....