Topics
Content Types
About 20 results
-
5 rules for embedding strings in VBA code
Don't struggle to pass strings. Instead, apply these five simple rules when working with embedded strings in VBA.
-
10 ways to screw up your VBA code
It's easy to get enticed into cutting corners when you write VBA code -- but that's likely to create problems down the road. Susan Harkins looks at some misconceptions that lead t...
-
Five tips for writing better VBA code
You can produce efficient, reliable, and easy-to-maintain code by following a few best practices. Susan Harkins reviews some essential aspects of good VBA code writing.
-
Render an Excel Defined Name invisible to users
Defined Names don't have to be visible to everyone, if you use VBA to create them.
-
Use VBA to return the next Saturday
Let VBA schedule your next weekend off. Just use this simple VBA function to return the date of the next Saturday.
-
Let VBA identify mistakes when you're entering code
This simple tip for entering VBA code can help you quickly discern mistakes.
-
Use a VBA function to populate list controls with names of months
You can quickly populate Office list controls with the months of the year. Thanks to the MonthName() function, a simple VBA loop will do the trick.
-
How to use the At and Ln indicators in Word's status bar
Word's status bar displays a couple of mysterious values, At and Ln -- learn what they mean and how to access them using VBA.
-
Office poll: Rate your level of expertise with VBA
This week's Office poll asks you to rate your VBA skills.
-
Can a small IT consultancy benefit from a Web site?
For many businesses, the Internet is the land of opportunity, but is it the right frontier for a small IT consultancy? Susan Harkins ponders whether a Web site will pay off for her...