Excel Training Boise

Listen to the grapevine.

Jared Hawk teaches Microsoft Excel Computer Classes in Boise, ID.

If you need to generate a time-stamp automatically in a spreadsheet (to tell when the last time a macro was run, for example) and you don’t know VBA or are intimidated by it, you can use the macro recorder. Keep in mind that if you use the standard functions:

=today() or =now()

as you record, they will be accurate- temporarily, but the formulas will update as the time changes, giving the wrong time stamps. 

A solution is simple: creat a macro that copies the date/time and then use paste special to paste the value only. The pasted value will not update.

Jared Hawk is a professional Microsoft Excel Seminar Trainer and Consultant in Boise, ID. He is also a contributing author to www.masterthebusiness.com and idahocle.com

Jared Hawk is a professional Microsoft Excel Instructor and Consultant in Boise, Idaho. He is also a contributing author to www.masterthebusiness.com.

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!

Jared Hawk is a professional Excel Seminar Trainer and Consultant in Boise, ID. He is also a contributing author to www.masterthebusiness.com.