Help of VBA?

Y

y

Where May I get an VBA reference?
You told me the F2-way to access the VBA instructions. But inside it there are not explanations. And
VBA help don't find all things I ask it.

Thanks Alex.
 
T

Tom Ogilvy

There is no complete vba reference beyond help that I am aware of. There
are many books written on Excel, Excel VBA and VBA.


F1 is the usual way to get help. Another path is to use the object browse,
find the property or method of interest, highlight it and hit F1.
 
E

Ed

Alex:

I'd start with Ron DeBruin's Google Search Add-In:
http://www.rondebruin.nl/Google.htm. This gives you wide access to the
newsgroups and their archives. Rarely is a question new; find out what's
already been asked and answered.

Here's one place to check for books:
http://www.ozgrid.com/Services/ExcelBooks.htm. Also:
http://www.contextures.com/xlbooks.html.

As for the Help files, they can be frustrating at first. I have found that
it's usually because Help answers a specific question about a specific
function, and I am wanting a general answer to a broader question. The Help
files are pretty good if you know what question to ask. I have also found
that, if I don't know what question to ask, I may not have a firm grasp on
what my problem really is.

Good luck. I dove head-first into VBA about a year ago, and learned most of
what I know now from the excellent folks here on the newsgroup. Now I've
gotten a few cash awards here at work for stuff I've done with macros - not
to mention saving myself and others countless hours of work time!

Ed
 
Top