Toggling Font Assignments in a Macro

Jacie wrote that she had created a macro that set text to Time New Roman. She wanted to change the macro to be a toggle between Times New Roman and Arial Narrow Bold, and wondered how to do it.

The easiest way to do it in a macro is simply to check the font used in your selected text, and then take steps based on what you find. For instance, the following macro will only take action if the selected text is either Times New Roman or Arial Narrow:

Sub ChangeSelectedFont()
    Select Case Selection.Font.Name
        Case "Times New Roman"
            Selection.Font.Name = "Arial Narrow"
            Selection.Font.Bold = True
        Case "Arial Narrow"
            Selection.Font.Name = "Times New Roman"
            Selection.Font.Bold = False
    End Select
End Sub

There is a different, non-macro way that may make some sense, however. Why not use styles? You can define styles to encompass any formatting attributes desired. For instance, you could define one style that used Times New Roman, and another that used Arial Narrow Bold. You could apply the styles at will, from the toolbar, and you could even search and replace using the styles.