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) ...

Visual Basic for Applications (VBA) stores spreadsheet names as string variables. Getty When you type data into an Excel workbook, the sheet's name appears in a tab at the bottom of the ...