I'm a newbie to VBA. Can anyone recommend me on the websites that allow me to learn the syntax of VBA? Could you also recommend me some useful websites for VBA beginner (an absolutely beginner with zero knowledge
)? i don't understand the source code that i've come across. Thanks alot.
| I think your best prospects for learning VBA revolve around two concepts: 1) to purchase books that discuss VBA in detail, and 2) learn how to use a MS application's Object Browser. With regard to 1), one of the books I purchased to learn VBA was a book called "Access VBA Programming" for dummies - it's the popular dummy series of books. The book is easy to read and understand. Start there, then read the online help associated with MS Access within the VBA editor - NOT the Help files associated with MS Access per se (there are two distinctive help systems). Other great books on VBA in the dummy series (published by Wiley Publishing) are "Excel VBA Programming for Dummies," "Excel 2003 Power Programming With VBA," and "VBA for Dummies, 4th Edition." With regard to 2), you want to learn how to use the Object Browser of a MS application. This will help you tremendously in learning the various methods and properties of ALL VBA objects within a particular library. For more information on the use and application of the Object Browser, go to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/html/vxurfObjectBrowserS.asp. Brice Richard |
Thank you very much for your advice. I've borrowed "VBA for the dummies from the library". 3rd edition though. i hope that should be ok. As for the Object Browser, this is the 1st time i ever heard of it. i'll go to explore that. thanks once again
.
