>GRSoftware >VBA Tutor >Newsletter Issues >Newsletter #9 >Newsletter #11

VBA TUTOR NEWSLETTER #10 ~ 1-6-2000 Help for the beginner to intermediate VBA programmer Subscribers 295 ~ ^40 in May

In this first monthly issue I hope to provide a better resource than the previous bi-weekly issues so that, hopefully, you find something of relevance to you in each issue! The change in style has been based upon the web design concepts found in Designing Web Usability - The Practice of Simplicty by Jakob Nielsen.

~ VBA in GENERAL ~

The tutorial for this month looks at the concept and use of 'Objects' in VBA programming. Although aimed at beginner VBA users, the tutorial goes on to look at the concept and use of user created objects for intermediate VBA users, and concludes by looking at 'Object' Arrays for more advanced users. [ SKILL LEVEL: ALL ]

~ COOL VBA RESOURCES ~ The Best of ZD Journals' Web and Programming Department's Tips, Techniques and FAQ links. [$19.95] This CD is packed with the best from Active Server Developers Journal, Automating Office with VBA, Inside Microsoft FrontPage, Inside the Internet, Inside Visual Basic and Microsoft Web Builder. 'SAMS Teach Yourself MS Excel 2000 Programing in 21 Days' OR 'Access 97 Unleashed, Second Edition' are just two of the titles to be found at ZDNet 'Instant Books.'

~ VBA in WORD ~

The easiest way to restore "Normal.dot" to its default state is to delete it, as WORD will automatically create a new default "Normal.dot" when it cannot find it in the Template folder!

~ COOL WORD RESOURCES ~ A MS Word Tip on how to use the 'Me' keyword to represent the object where an 'event' has occured @ MS Word Developer. [ SKILL LEVEL: Beginner to Intermediate]

~ VBA in EXCEL ~

If you use 'UserForms' in your Excel applications, you can reduce the amount of time you spend on formatting by setting attribute properties at the 'UserForm' level. Any controls you add to the 'UserForm' will inherit those properties by default.

~ COOL EXCEL RESOURCES ~ A few Excel tips @ spreadsheets.home.mindspring.com. [ SKILL LEVEL: All ]

~ VBA in ACCESS ~

As you enter records in an Access table, you may find that much of the data remains the same in some fields from record to record. You can quickly copy information from the previous record by pressing [Ctrl]+ ['].

~ COOL ACCESS RESOURCES ~ Have a look at this list of Web resources where you can find answers to questions about ACCESS solution development @ ACCESS Development Links. [ SKILL LEVEL: All ]

VBA TIP REQUEST FORM Contact Name: Tip Request: Unsubscribe from this newsletter!

© 2000 Gary Radley