| >GRSoftware >VBA Tutor >Newsletter Issues >Newsletter #11 >Newsletter #13 |
|
VBA TUTOR NEWSLETTER #12 ~ 1-8-2000
Help for the beginner to intermediate VBA programmer
Subscribers 490 ~ ^130 in July
|
Sorry I was not able to be of much help with several involved queries this month, but being away for a two week holiday left me running a bit short of time.
|
| ~ VBA in GENERAL ~ |
[1] The tutorial for this month looks at creating a UserForm for a font underlining macro. It steps through each stage from creating a module to contain the code and UserForm, to creating the UserForm and controls and altering their properties.
[SKILL LEVEL: Beginner To Intermediate]
[2] To find out a function or objects named arguments, select the function in your code then press [F1].
[ SKILL LEVEL: ALL] |
~ COOL VBA RESOURCES ~
Have a look at the past issue of the "Office Talk" column @ msdn online.
[ SKILL LEVEL: Intermediate to Advanced ]
|
| ~ VBA in WORD ~ |
Going to create a PowerPoint presentation based on a Word document? Why bother cutting and pasting from Word to PowerPoint when you can use "File | Send To | Microsoft PowerPoint". PowerPoint will automatically open, import the the text in your Word document, then create slides according to the paragraph and style used in the Word document. |
~ COOL WORD RESOURCES ~
Some free cool Word utilities can be found @ CDEV Computing. You can also find informaion about VBA Programmer training in the UK, Word News and Views, as well as a selection of Word Solutions.
[ SKILL LEVEL: Beginner to Intermediate]
|
| ~ VBA in EXCEL ~ |
Having trouble getting text to wrap the way you want in Excel cells. Then enter [Alt]+[Enter] whenever you want to force a hard return. |
~ COOL EXCEL RESOURCES ~
Learn how to design form templates for Excel @ www.zdnet.con/zdhelp/
[ SKILL LEVEL: Intermediate to Advanced ]
Although the web design of this English/French web site makes it difficult to navigate easily, there are some excellent VBA in Excel tips at @ www.cyberfrench.com.
[ SKILL LEVEL: Intermediate to Advanced ] |
| ~ VBA in ACCESS ~ |
If your Access report lists duplicate data in a column, they can be hidden.
First, open the report in Design view and select the control that displays repetitive information.
Then, display the control's Property sheet and set the Hide Duplicates property equal to Yes.
Finally, save and preview your report. If the data in the modified control is the same as the data from the previous record, the control is hidden. |
~ COOL ACCESS RESOURCES ~
You might find some useful Access and VB tips to do with 'QueryDef', 'RecordSet' and 'DLookup' @ http://home.i1.net/~caver/aindex.html.
[ SKILL LEVEL: Beginner to Intermediate ] |
 Unsubscribe from this newsletter!
|
| © 2000 Gary Radley |