>GRSoftware >VBA Tutor >Newsletter Issues >Newsletter #beta >Newsletter #2

VBA TUTOR NEWSLETTER #1~ 1-1-2000
Help for the beginner to intermediate VBA programmer

Welcome to the first issue of VBA Help! In each edition, we will try to provide some tips and links for both the beginner and intermediate programmer. Hopefully, you will learn a little more each issue.

~ VBA in GENERAL ~

For the first tip, we can only emphasis that the easiest way to learn how to use VBA is to use the 'Macro Recorder' and the 'Office Assistant' in combination. Together, they provide the easiest and the simplest way to both initiate and complete a project. So, for you beginner VBA programmers, go to the following tutorial, tut1.htm, to see how it's done.

~ VBA in WORD ~

You intermediate programmers will know it's easy to improve/extend a standard Word Menu Item by creating a macro of the same name. But how do you find the macro name to replace? Easy!
1: Press the 'Ctrl'+'Alt'+ number pad '+' key together. The mouse cursor will change to resemble a cloverleaf.
2: Click on the Menu Item you want to change and the 'Customise Keyboard' dialog box will open, giving you the macro name of the selected Menu Item.
[ Issue 2 tutorial will extend upon tutorial 1 and look at how to extend the standard Menu Items ]

~ COOL WORD RESOURCE ~
Scott Matthewman's ~ VBA Tips

~ VBA in EXCEL ~

Ever had trouble referencing a particular worksheet. Could be it had a space in it's name, such as 'sheet 1'. To overcome this problem, enclose the worksheet name in apostrophes inside the quotation marks. eg. ("'Sheet 1'!A1")

~ COOL EXCEL RESOURCE ~
'30 EXCEL secrets' from the Microsoft Knowledge Base.

~ VBA in ACCESS ~

Using VBA in ACCESS is not one of our strengths, so in this section we will just point you towards some excellent resources.

~ COOL ACCESS RESOURCE ~
'ACCESS Hints and Tips from ALDEX Software Ltd, UK.
[ SKILL LEVEL: Intermediate to Advanced ]

Unsubscribe from this newsletter!

© 2000 Gary Radley