>GRSoftware >VBA Tutor >Newsletter Issues >Newsletter #12 >Newsletter #14

VBA TUTOR NEWSLETTER #13 ~ 1-9-2000 Help for the beginner to intermediate VBA programmer Subscribers 585 ~ ^95 in August

Thanks for the suggestions sent about a more advanced tutorial for next month issue, as they have been helpful in steering me towards giving you what you want from this newsletter. I hope you look forward to next months tutorial which looks at 'CREATING AND USING AN 'XLA' ADD-IN FILE'.

~ VBA in GENERAL ~

[1] The tutorial for this month looks at creating a a 'Favorite' custom button for the Toolbar. It steps through each stage from creating the macro to assigning a new button to a toolbar. [SKILL LEVEL: Beginner ] [2] For access to 300,000 articles and abstracts from over 200 of the most influential computer-related magazines, journals and newspapers, have a look @ Znet TECH INFOBASE. [ SKILL LEVEL: ALL ]

~ COOL VBA RESOURCES ~ Have a look at Scott Matthewman's 'VBA Tips' site for some excellent VBA code examples. [ SKILL LEVEL: Intermediate to Advanced ]

~ VBA in WORD ~

Ok! Truth time! How many of you use the AutoText feature ['Insert | AutoText' ] of Word to automate your work? Although refered to as "AutoCorrect", it can be used as "AutoComplete". For example, typing "New Y" + "space", can be 'Auto Completed' to "New York". That is only a simple example, but think of how many other words and phrases that you use frequntly that could be easily 'Auto Completed'. It only takes a few seconds to add such completions in the 'AutoCorrect' dialog. [ 'Tools | AutoCorrect' ]. Use 'Help' for a full explanation of what to do!

~ COOL WORD RESOURCES ~ For an clear explanation of how to define procedures in VBA, look at the MSDN Online Library. [ SKILL LEVEL: Beginner to Intermediate ]

~ VBA in EXCEL ~

To prevent getting lost in a large worksheet you can freeze headings so that you always know what data you're looking at. To freeze a row, select the row number or the cell in column 'A' that's immediately beneath the last row you want frozen. Then, select 'Window | Freeze Panes' from the menu bar. Excel inserts a thin line to show you where the frozen pane begins. To freeze a column, select the column letter or the cell in row '1' that's immediately to the right of the last column you want frozen. To freeze horizontal and vertical headings simultaneously, select the cell that's in the upper-left corner of the range you want to remain scrollable and then invoke the Freeze Panes feature. To restore the workbook to its normal view, select 'Window | Unfreeze Panes' from the menu bar.

~ COOL EXCEL RESOURCES ~ [1] Find some excellent VBA code examples and explanations @ Add-ins for Excel. [ SKILL LEVEL: Intermediate to advanced ] [2] Although the site navigation is not helpful, there is some good Excel code examples and explanations @ Erlandsen Data Consulting. [ SKILL LEVEL: Beginner to Intermediate ]

~ VBA in ACCESS ~

If you've ever tried to use the Microsoft Web Browser control in an Access 97 form, you may have been greeted with the error messsage "There is no object in this control". This is because Access 97 isn't compatible with an updated DLL that was introduced with IE 4.0. To fix the problem, draw your browser control on the form, select it and press '[Ctrl]X' to cut it. Immediately press '[Ctrl]V' to paste it back on the form. After repositioning the browser you'll find that you can now open the form without errors.

~ COOL ACCESS RESOURCES ~ Access (& some Excel) code examples @ www.planet-source-code.com [ SKILL LEVEL: Intermediate to Advanced ]

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

© 2000 Gary Radley