VBA TUTOR

FREE Online LessonsVBA TutorBuy VBA Tutor 2007/2008VBA TutorVBA TutorFREE Demo Download
Newsletter IssuesVBA TutorNewsletter TutorialsVBA TutorTrial SoftwareVBA TutorCosting Add-InVBA Tutor Excel Add-Ins

The home of 'VBA Tutor'

The internets #1 VBA Tutorial - Reorganised & Updated for latest OFFICE versions
Find out more ... VBA TutorialTry the FREE lessons ...

Software Industry Professionals Member
GRSoftware is a
Software Industry Professionals Member.

VBA for BEGINNERS!
Many web sites that try to be an introduction to VBA seem to be designed for the sole purpose of impressing others with the authors VBA programming skills. This site has been designed for those that have never done any computer programming and would like to "give it a go". I will try to impress you with how I can clearly and simply explain how to use VBA in WORD and EXCEL.

STEP ONE ~ Having the right frame of mind for VBA!
Computer programming is attempting to do with a computer what we do every minute we are awake, taking in information then making some decisions about it. You are doing it NOW! The information you have just read might lead you to decide to leave this page. Bye! OR, you might decide to continue and see what else I have to say about VBA. You have just done some computing.

STEP TWO ~ The VBA Tutorials!
Go to the Lesson pages and view online the first FIVE VBA lessons FREE!. If you wish to continue on after trying these free lessons, you can return to this website and purchase either VBATutor 2007 for OFFICE 2003 or VBATutor 2008 for OFFICE 2007. The complete package of VBA Lessons in both contains 40 VBA lessons and 14 VBA help and example files.
[ VBATutor 2007 is Aus$15.00 (App. US$12.50) ] [ VBATutor 2008 is Aus$17.00 (App. US$14.00) ]

STEP THREE ~ Work at VBA!
Look through the back issues of the 'VBA Tutor Newsletter' (which is no longer distributed), as well as checking out the ' VBA Tutor Newsletter ' Tutorials. These sites offer tips, help and links that you can use to become a WORD and EXCEL ..... VBA POWER USER!

VBA FAQ?

What is VBA?

Visual Basic for Applications (VBA) is an implementation of Microsoft's Visual Basic, an event driven programming language and associated development environment which is built into most Microsoft Office applications (including Apple Mac OS versions), some other Microsoft applications such as Microsoft MapPoint and Microsoft Visio - a former independent application which was acquired by Microsoft; as well as being at least partially implemented in some other applications such as AutoCAD, WordPerfect and ESRI ArcGIS. It supersedes and expands on the capabilities of earlier application-specific macro programming languages such as Word's WordBasic, and can be used to control almost all aspects of the host application, including manipulating user interface features such as menus and toolbars and working with custom user forms or dialog boxes.
(Definition from Wikipedia)

What is the 'ESSENCE' of VBA?

To understand the 'Essence' of VBA, you must understand that every part of a MS Office program is made up of 'Objects', and these Objects have 'Properties' that can be 'set' or 'altered' in response to a user initiated 'Event' such as a 'mouse click' or a 'keypress'.

In WORD for example, the 'Menu Bar' is an Object. The 'Header' and 'Footer' are objects. The whole document, individual pages, a paragraph, a sentence, a word, an individual character are also objects.

All of these Objects have 'Properties'.
Some of these properties are either 'true' of 'false'. For example, a selection of text could have its 'bold' property set to 'true'.
Some of these properties could have a 'numerical' value. For example, a selection of text could have its 'size' property set to '36'.
Some of these properties could have a 'text' value. For example, a selection of text could have its 'color' property set to 'wdRed'.

All of these Objects can react to 'Events'.
Using a mouse or a keyboard, the user initiates an 'Event'. For example, clicking on the 'Font Size' menu item in the main toolbar, will initiate the Event of the dropping down of the Font Size selection box.

VBA 'controls' this interection between 'Objects' and their 'Properties' in response to a user initiated 'Event'

This is the 'ESSENCE' of VBA!

What is VBA used for?

A common use of VBA is to add increased 'functionality' or some 'automation' to the various MS OFFICE programs.

For example, you could access a commonly used menu item that you commonly use, such as the 'Statistics' tab from the document 'Properties' item from the 'File' menu, which is not easily accessable, to be instantly accessed by a hot key.
Or, you could automate a series of commonly performed procedures or actions. For example, you might commonly enter data into a table then do some calculations and/or formmating of that data. VBA can be used to automatically do the calculations and/or formatting of this data.
To get some idea of what can be done using VBA, do a web search for 'VBA Addins'.

How can I use VBA?

If you have any of the MS OFFICE programs installed you can use VBA, as all these programs have a VBA editor, called the 'VBE' (Visual Basic Editor), inbuilt.

You will then need a tutor to show you how to use the 'VBE' to create VBA projects.

The internets #1 VBA Tutor, available in versions for both Office 2003 & 2007, is available from this very page! Why not give it a FREE try?


HomeVBA TutorBuy VBA Tutor 2007/2008VBA TutorDemo DownloadVBA TutorFree Lessons
Newsletter IssuesVBA TutorNewsletter TutorialsVBA TutorTrial SoftwareVBA TutorCosting Add-InVBA Tutor Excel Add-Ins

© 2007 Gary Radley
Lily's Jewellery












VBA Help Tutor for Office 2003 and 2007 / XP Word and Excel. Help and Free Lessons with VBA macros and automation.

VBA Tutor is a Visual Basic for Applications tutorial and help for word, excel and access package, containing free tutorials and free lessons. The excel, word and access lessons for VBA (Visual Basic for Applications), includes VBA macro and macros lessons and examples with VBA automation addin or addins for Office 2003 and 2007 and word, excel,and access. Visual Basic for Applications Tutor is used to aid the learning of VBA with word, excel and access, with the free tutorials carefully designed to aid learning using examples lessons. The WORD, EXCEL and ACCESS lessons for VBA and Visual Word Basic, includes macro and macros examples with VBA automation addin or addins for Office programs.



VBA Software Free Software and Game DownloadsFree Software and Game Downloads Soft32Best
Popular Software Library Trial Software Library

Gear's Box - ultimate collection of quality software
ProgramsHome.com
Yankee Download - free software downloads
www.1000apps.com - A selection of softwares, freewares and sharewares to download.
Mischief Motivation Attitude
SEO optimisation by GRSoftware