VBA Reference Book

[apndas]

What would rate as the best VBA reference book if I'm wanting to
understand the fundamentals/structure of VBA and learn/develop my
programming skills. I have investigated shortcourses etc, but they
seem to usually run 2 days tops and to me that does not seem sufficient
to gain an understanding of VBA. I don't have a programming background
hence I am not familiar with VB etc etc. Is that perhaps something I
should be looking into? Currently I just plagiarise code from the net
and would prefer to understand in depth what I am copying. I accept
time and practice is paramount, however I would just like to set the
foundations "correctly"

I appreciate any feedback in advance

Regards
Darren

 

[NickHK]

Darren,
Firstly, get used to starting with the macro recorder to generate workable
(but not always the most efficient) code.
From this code, you can remove the mistakes and (normally) the .Select(s) to
give you an idea of the properties/function/etc required to achieve your
goal.
The Help files and Object Browser should also become familiar to you.

After that, start at your local library and when you outstrip the level
available there, you should have a better idea of further references to
excel.
I have seldom seen much that would draw me courses, if it involved my own
cash.
My $0.02.

NickHK

 

[Bob Phillips]

Try starting here


'Getting Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


You might also look at David's tutorials page at:

http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials




--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Tim Williams]

http://www.amazon.com/gp/product/07...ef=sr_1_1/103-3310988-6715820?ie=UTF8&s=books

....or earlier edition depending on your Excel version.