Staff Trainer | A Human Resource & Management Blog

Have you ever used radio buttons on your Microsoft Document, but to your dismay realize that only one button at a time- on the entire document- can be selected? You can simply work around this by using a group box.
In Excel, make sure your forms box is visible, select group, and simply draw it around the radio buttons. If you are printing the form, you can make the box invisible by right-clicking it, selecting format control, and under properties uncheck “Print Object.”

There is a great post on workplace jerks and bullies on the human resource blog - one thing it doesn’t address is that some companies foster bullying and jerk behavior. If you are in that environment, look for a company that embraces the principles in the post.

Two great sites you should check out are elance.com and scriptlance.com where you can find worldwide experts to do just about any type of contract work you need. I use both of these sites, but do your homework on the people you select to work with- I was already started on a project for a consumer before I realized the spreadsheet he sent me to modify was a commercial demo. It would have cost him less to have me crack open that file than to buy a legal copy. Yeah, I terminated that project.

Can you use Excel’s text-to-speech functionality in VBA? You bet. Simply use this line of code: application.speech.speak and then specify your text in paranthesis or you can even use a variable. If your variable was called Announcement, your code would look like this:

application.speech.speak announcement

And to read text:

application.speech.speak (”This is the text!”)

Simple!