>GRSoftware >VBA Tutor >Newsletter Issues >Newsletter #13 >Newsletter #15

VBA TUTOR NEWSLETTER #14 ~ 1-10-2000
Help for the beginner to intermediate VBA programmer
Subscribers 665 ~ ^80 in September

I am still not getting enough suggestions for more advanced tutorials. So, if you would like a tutorial on a particular topic, please let me know.

~ VBA in GENERAL ~

[1] The tutorial for this month looks at 'CREATING AND USING AN 'XLA' ADD-IN FILE'. For advanced users wanting to distribute their project(s), 'xla' add-ins are the ideal solution for storing and distributing complete applications, or custom functions and utilities.
[SKILL LEVEL: Intermediate to Advanced ]

~ COOL VBA RESOURCES ~
[1] Have a look at this short discussion on when to use 'If ... End If', 'If ... ElseIf ... End If' or 'Select Case ... Case ... End Case' @ Znet Help!
[ SKILL LEVEL: Beginner to Intermediate]

[2] For a clear explanation of 'Code Modules' and 'Code Names', have a look @ Pearson Software Consulting
[ SKILL LEVEL: Intermediate to Advanced ]

~ VBA in WORD ~

Want to sort the cells in a single table column only.
Select the table column you'd like to sort.
Choose 'Table | Sort' from the menu bar.
In the Sort dialog box, click the 'Options' button.
Select the 'Sort Column Only' check box, and then click 'OK' to return to the Sort dialog box.
Select the sort criteria you'd like to use, and then click 'OK' to perform the sort.
Want to do the same in a vba macro, then record the procedure using the macro recorder.
NOTE: The 'Sort Column Only' feature remains active until you close Word.

~ COOL WORD RESOURCES ~
There are some excellent Word tips @CNET Coverage
[ SKILL LEVEL: Beginner to Intermediate]

~ VBA in EXCEL ~

If you do not like 2000's new menu system you can revert to the standard menu behavior you're used to.
Right-click on the menu bar and choose Customize from the shortcut menu.
Cick on the Options tab of the Customize dialog box.
Clear the Menus Show Recently Used Commands First check box.
Click Close.

~ COOL EXCEL RESOURCES ~
[1] For those subscribers that do not use Excel, but would like to learn, have a look at this very clear tutorial on using Excel, @ Excel Tutorial by Professor Richard Falk
[ SKILL LEVEL: Beginner ]

[2] There are some 'excel'lent tips @ CNET Coverage
[ SKILL LEVEL: Beginner ]

~ VBA in ACCESS ~

Ever wanted to have a "&" in a lable? Then just enter "&&", such as "Oranges && Lemons" for example.

~ COOL ACCESS RESOURCES ~
[1] Some good Access code and examples can be found @ Tips for Access Database Users.
[ SKILL LEVEL: Beginner to Intermediate ]

[2] Some downloadable Access 97 Notes and sample applictions such as an internet updatable stock portfolio can be found @ Chuck's Access 97 and Windows 98 tips.
[ SKILL LEVEL: Beginner to Intermediate ]

© 2000 Gary Radley