VBA source or reference

[pogiman via OfficeKB.com]

What book or site (other than www.officekb.com) would you recommend to learn
Excel VBA (or VBA even in other MS Office applications)?

Though I could search the internet for VBA codes whenever I need one but I
really want to learn and equip myself with it.

Thanks for your response.

 

[stanleydgromjr]

pogiman via OfficeKB.com,

Training / Books / Sites:

How to Learn to Write Macros
http://articles.excelyogi.com/playin...ba/2008/10/27/

How to use the macro recorder
'Excel Yogi’s' (http://articles.excelyogi.com/)

Click here and scroll down to Getting Started with VBA.
'DataPig Technologies
(http://www.datapigtechnologies.com/ExcelMain.htm)

If you are serious about learning VBA try
'Visual Basic Macros Made Easy' (http://www.add-ins.com/vbhelp.htm)

Excel Tutorials and Tips - VBA - macros - training
'Excel Tutorial | Excel Tips | Excel Articles
(http://www.mrexcel.com/articles.shtml)

See David McRitchie's site if you just started with VBA
'Getting Started with Macros and User Defined Functions
(http://www.mvps.org/dmcritchie/excel/getstarted.htm)

Debra Dalgleish has some notes how to implement macros here:
'Excel VBA -- Adding Code to a Workbook
(http://www.contextures.com/xlvba01.html)

David McRitchie has an intro to macros:
'Getting Started with Macros and User Defined Functions
(http://www.mvps.org/dmcritchie/excel/getstarted.htm)

Ron de Bruin's intro to macros:
'Where do I paste the code that I want to use in my workbook
(http://www.rondebruin.nl/code.htm)

'Free Help on VBA for Excel (Macros)' (http://www.excel-vba.com/)
'Getting Started with Macros and User Defined Functions
(http://www.mvps.org/dmcritchie/excel/getstarted.htm)
'Microsoft Excel Links / Microsoft Excel Tips / Excel Tutorial / Exce
Spreadsheet Help / Excel Tip .com
(http://www.exceltip.com/excel_links.html)

(livelessons video)
Excel VBA and Macros with MrExcel
ISBN: 0-7897-3938-0
http://www.amazon.com/Excel-Macros-M...7936479&sr=1-1

Excel 2003 Power Programming with VBA, by John Walkenbach
VBA and Macros for Microsoft Excel, by Bill Jelen "Mr.Excel" and Trac
Syrstad
Excel Hacks 100 Industrial-Strength Tips & Tools, by David & Train
Hawley
VBA and Macros for Microsoft Excel 2007, by Bill Jelen "Mr.Excel" an
Tracy Syrstad

Excel 2007 Book: you can try this...there is a try before you bu
ebook available at this link…
'Learn Excel 97 through 2007 from Mr Excel - Revised and Expande
Second Edition' (http://www.mrexcel.com/learnexcel2.shtml)


Have a great day,
Sta

 

[pogiman via OfficeKB.com]

I see I have a lot of catching up to do.

Thank you very much stanleydgromjr.

 

[seena]

What percentage of your development time would you say that you spen
debugging code? Most developers I've talked to say they spend anywher
from 30% to 50% or more of their time -- not writing the code -- bu
debugging and fixing it. Not only do we use the debugger to check cod
we've written before we can go on to write some more, we also use it i
testing a completed project under various sce...

 

[Bob Phillips]

80%, and the other 80% writing code.