>GRSoftware >VBA Tutor >Newsletter Issues >Newsletter #20 >Newsletter #22

HotBot

Search the Web:

Hi, I'm back!

After a five week holiday in Europe, I am over the jet lag and back on board. This will be a pretty brief Newsletter, just mainly touching base and keeping contact. There will be another one in two weeks time. Until then ....

Gary Radley

GRSoftware

**********

VBA TUTOR MONTHLY NEWSLETTER: #21  ~ 1/5/2001

[ 1350 Subscribers ~ ^150 in April ]

**********

VBA UPDATE & NEWS:

*********

SITE #1: ~ http://www.microsoft.com/presspass/press/2001/Feb01/02-05NamingPR.asp

Find out about the newest version of OFFICE, OFFICE XP.

SITE #2: ~ http://www.microsoft.com/office/trial/default.htm

Trial / Preview Office XP. (USA and Canada ONLY!)


**********

WORD TIP:

Most people only use a small percentage of the power of WORD. One of the most powerful features of WORD is the ability to record and use macros to automat many repeatative tasks. Follow the link below for a thorough overview of how to use the power of WORD macros to increase your productivity. While at this site, you can also sign up for the Business Software Newsletter, which I have found to be an excellent source of information and tips. WORD MACRO LINK


EXCEL TIP:

The default font in EXCEL is 10 point Arial, which can be a little small with large monitors. You can choose a larger default font size by first selecting Tools | Options on the menu bar, then select the general tab. Use the dropdown lists to select a new default font and size, then click OK to finish. However, be aware that this will alter the printer output.
Another solution is to alter the zoom view by selecting View | Zoom, then selecting one of of the preset sizes or create your own custom size. This will not alter the printed output.


ACCESS TIP:

To insert a line break in a label caption that will not only display properly, but will print properly, include both a line feed character and a carriage return character.
For Example:
Me.Label1.Caption = "This is the first line of text!" & Chr(13) & Chr(10) & "This is the second line of text!"

**********

If you wish to unsubscribe, send an email with "unsubscribe" as the subject to unsubscribe@austarnet.com.au

**********