Hi,
Im looking for a book to learn VBA aswell, However being a Commerce grad through and through have absolutely no prior experience with coding.
I am able to record macro and do minor editing. But writing one from scratch.
Only need macros for excel though..
Any books that someone can suggest me?
Thanks in advance
A place to start is http://spreadsheetpage.com/Originally Posted by PSL
Check out John WAlkenbach's book, listed at that web site.
Start with the Power Programming and Formulas books.
Also, http://www.bmsltd.co.uk/ProExcelDev/Default.htm
A quick start, if still published, would be the MSFT Press' Excel VBA Step by Step.
Fellows,
Is there available a CD of Training, like, lynda.com for learning VBA ?
Comments please.
MrExcel.com has some good resources as well for VBA examples. The CD with examples on it is very nice. I think there is a cost associated with it though.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Many thanks.
The best books I've ever found is www.google.com and www.vbaexpress.com/forum. First to find the reference to each function/method, second for finding ideas, solutions and testing your skills.
Can anyone help me to grab a free beginners book on EXcel and Access VBA.
Books aren't free. A lot of online material, however, is free. Your best bet is to take a look at the Resources page, where you'll find many helpful sites, free help boards, blogs, etc.
HTH
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Sometimes books are free.
http://www.vbaexpress.com/forum/showthread.php?t=1890
http://vbaexpress.com/forum/showthread.php?t=24408
Excel 2003, WinXP
LOL! Touche.Sometimes books are free.
http://www.vbaexpress.com/forum/showthread.php?t=1890
http://vbaexpress.com/forum/showthread.php?t=24408
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
LOL! Touche.,
Excel 2003, WinXP
I recommend VBA the bible. It is almost as good as searching information from forum sucha as this one!
VBA won't help much if you do not master.
So you should start by learning those inside out (in interactive mode first), and do not hesitate to try them out, even with Access macros. After that, your VBA will be much simpler to write. I see too often would-be-developers spending lots of time writing code to re-create functionalities that are already built in the product.
Where is a good place to purchase the books?
Try Amazon
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
There is at least one free VBA e-book on Amazon Kindle at the moment (i.e. July 31st)
I think it's worth a look, for beginners.
I found really usefull an online course (with written material attached) on lynda (lynda.com), it was called macros in depth or something like that! really usefull (more than just a book anyway)
There's a few good ones on amazon but they seem very expensive sadly
some book in spanish? thanks!
Posting Permissions
