Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Reference Book
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 -- apndas ------------------------------------------------------------------------ apndas's Profile: http://www.excelforum.com/member.php...o&userid=36137 View this thread: http://www.excelforum.com/showthread...hreadid=560610 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Reference Book
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 "apndas" wrote in message ... 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 -- apndas ------------------------------------------------------------------------ apndas's Profile: http://www.excelforum.com/member.php...o&userid=36137 View this thread: http://www.excelforum.com/showthread...hreadid=560610 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Reference Book
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....htm#tutorials -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "apndas" wrote in message ... 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 -- apndas ------------------------------------------------------------------------ apndas's Profile: http://www.excelforum.com/member.php...o&userid=36137 View this thread: http://www.excelforum.com/showthread...hreadid=560610 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Reference Book
http://www.amazon.com/gp/product/076...e=UTF8&s=books
....or earlier edition depending on your Excel version. -- Tim Williams Palo Alto, CA "apndas" wrote in message ... 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 -- apndas ------------------------------------------------------------------------ apndas's Profile: http://www.excelforum.com/member.php...o&userid=36137 View this thread: http://www.excelforum.com/showthread...hreadid=560610 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can anyone recommend a reference book | Excel Worksheet Functions | |||
VBA Reference Book? | Excel Discussion (Misc queries) | |||
VBA Reference Book? | Excel Programming |