![[Bytes Link logo]](../../../cgif/bytelnk2.gif)
Learning Visual Basic for Applications for Office 2000
by By John David Phillips — 1960 PC Users Group August 2000, johndavidphillips@yahoo.com - October 07, 2000 at 00:28:38:
If you use Microsoft Office with any regularity, you will eventually hear about macros. What are they? A macro is a series of commands (a program) that runs inside Office. Many people think negatively of macros because many viruses are spread through their use; however, macros can be very beneficial. Visual Basic for Applications (VBA) is the standard development language used to write macros for all of the Office products. Writing macros can be a daunting task for even the expert computer user. The Learning Visual Basic for Applications for Office 2000 training CD from ViaGrafix (now Learn2.com) teaches you how create macros to increase your productivity.VBA is not for beginners. The language used in VBA is practically identical to the Visual Basic 6 programming language. It is important for you to know this before starting the tutorial; otherwise, you can become frustrated quickly. Before viewing the training CD for the first time, I had very little programming experience (a little QBasic, HTML, and JavaScript). The first two chapters of the tutorial were fairly simple, but the last two blew me away. I have since taken a college course in programming logic. When I viewed the CD tutorial again, it made much more sense. Conclusion: the training CD assumes the viewer has a working knowledge of Visual Basic 6.
What will you learn? The potential of VBA is almost limitless, but this tutorial only covers basic and intermediate VBA topics including the following:
• Using the Visual Basic Editor
• Using variables
• Programming with loops
• Working with subs, functions, and argument
• Creating user forms for Office products
• Creating arrays
If you are interested in using VBA in any Office application, I would recommend that you view Learning Visual Basic for Applications for Office 2000. Keep in mind that it is intended for fairly advanced users with a working knowledge of Visual Basic 6. This very interesting training CD is available in our club’s training library—check it out today!
John David Phillips is a college student as well as a computer consultant. He is a member of the 1960 PC Users Group and can be contacted via e-mail at johndavidphillips @yahoo.com.
![[------STRIPE-----]](../../../cgif/str1.gif){kind=small}
Site Disclaimer Suggestions? E-Mail to webmaster@noccc.org