If you want to accomplish the same thing from inside Excel—for instance, display and populate an appointment while working in Excel—you’ll need a bit of VBA magic.

Fortunately, you can do so with VBA. In this article, I’ll show you a VBA procedure that changes the format properties for the active cell. SEE: 83 Excel tips every user should master (TechRepublic) ...