Visual Basic for Applications
A quick macro to aid in HTML scripting
- A quick macro to delete Excel rows
- Add items to a listbox control in Outlook
- Add recipients to an Outlook Automation email object
- Automatically validate InputBox values in Excel
- Choosing the right variable type for the job
- Debug with color
- Disable a UserForm's Close button
- Easy formatting with Word's collections
- Manipulate Office objects without selecting them
- Maximize UserForms
- Protect your code from prying eyes
- Reduce confusing Object Browser clutter with the Group Members option
- Remove Items from an MS Forms Listbox control
- Start the Visual Basic Editor
- Suppress Excel event procedures
- Truly hide a UserForm when you turn off screen updating
- Unconventional conditionals
- Use Excel's InputBox method in place of the RefEdit control
- What to do when a Word Automation object shows up naked
- When to use parenthetical arguments in VBA functions and methods