I recently saw a good post on Linkedin from Leila Gharani MVP on increasing the Excel Formula Bar font size. It seems useful for training, so I wrote a simple macro to simplify the process.

The macro changes the default font size for Excel (this includes the Formula Bar) you have to close Excel and re-open to see the change.

You need to reset it back to normal size once you no longer need the large size. The macro toggles between 12 and 24. See image below for the difference.

Sub Change_Default_Font()
'You need to close Excel and re-open
' for the change to take effect
 
    If Application.StandardFontSize = "24" Then
        Application.StandardFontSize = "12"
    Else
        Application.StandardFontSize = "24"
    End If
 
End Sub