What happened to my button?

I recently had a customer ask how he could freeze objects, in this case a set of buttons, so that they didn’t disappear as he scrolled through his Excel spreadsheet. This sounds like it would be a common request and have a topic in Excel help. However, that’s not the case. Help does explain how…

0

Get "Immediate" results when creating or debugging code

In my last blog, I talked about debugging with the Watch window where you can do things such as look at the value of  expressions at some point in the code execution and halt execution when a variable reaches a specific value. Other useful  tools to help with debugging are the Immediate window and the…

0

VBA Beginner’s Corner – Someone to Watch over you.

The Visual Basic for Applications (VBA) integrated development environment (IDE) seen in the Microsoft Office applications contains lots of tools to help you diagnose and fix errors in your code. However, many of us don’t take advantage of the tools that are there. Personally, the technique I relied on most heavily when I was first…

0

Using Northwind Traders can save yourself a lot of time

Since 1994, regardless of my actual job, I’ve always found a way to stay involved with Access. I’m certainly no expert but I like working with Access and with the people that work with Access. I just finished attending the MVP Summit in Redmond, my second, and it blows me away at the amount of…

1

Writing Technical Articles – Part 3

To recap, you’ve created a plan and an outline for your article. You’ve also added code samples or created the “to-die-for” tool or utility. And you’ve written your article as clearly and concisely as appropriate. Now it time for the scary part: letting others see your work. Getting others to review and comment on your work is…

1

Writing Technical Articles Part 2

Continuing my previous blog on writing technical articles, now that you have a plan, it’s time to create an outline. If done correctly, the outline can serve as the table of contents (if you use a TOC) for your article. Magazines and technical publication articles typically do not use a TOC; instead they usually use…

2

Writing Technical Articles Part 1 – Step up to the plate and share the wealth

I’m a programmer writer for the MSDN Office Developer Center. My job for the last five years is writing how-to articles for developers that appear on the Microsoft Developer Network (MSDN), specifically, Microsoft Office developers. I have a background as a Microsoft Access developer for approximately five years and as telephone support engineer for Access…

3