Good VBA reference guide

[Steve]

Hi,

I was wondering if any of you know if there is a VBA
reference guide available. I am looking for something
that lists all available functions, properties and
methods etc. instead of having to rely on the
autocomplete function and the object browser - which
usually falls short!
I have used VBA for Excel for quite a while...and I am ok
with the stuff I have already learnt but trying to learn
even the simplest things in terms of what i can use with
what I can usually only accomplish by accident.

Any help would be greatly received.

Steve

 

[Jan Karel Pieterse]

Hi,

I like these two:

Excel 2000/2002 VBA Programmers Reference. Stephen
Bullen, John Green, Rob Bovey, Robert Rosenberg. Wrox
Press.

Excel 2002 VBA Power Programming. John Walkenbach.

Regards,

Jan Karel Pieterse
Excel TA/MVP

 

[steve]

Thanks Jan, I'll check these out.

Steve

-----Original Message-----
Hi,

I like these two:

Excel 2000/2002 VBA Programmers Reference. Stephen
Bullen, John Green, Rob Bovey, Robert Rosenberg. Wrox
Press.

Excel 2002 VBA Power Programming. John Walkenbach.

Regards,

Jan Karel Pieterse
Excel TA/MVP

.