Tahoma Font Used in DialogSheets

Microsoft Excel 97 conforms to the rest of the Office suite and uses the Tahoma font in dialog sheets. The metrics of Tahoma are slightly smaller than those of MSSansSerif or MSSansSerif Bold, the fonts used in Microsoft Excel 95. There may be spacing issues in custom dialog sheets. The best way to work through this issue is to check all dialogs by eye and manually edit those that are affected. If you are developing an application for both Microsoft Excel 95 and Microsoft Excel 97 and want to ensure that your dialogs and dialog controls are correctly sized, you may change dimensions based on the version of Microsoft Excel that is running. For example, the following code discerns the version of Microsoft Excel and then adjusts a label based on the version:

Sub SizeByVersion()
    With ThisWorkbook
        If Application.Version <> "8.0" Then    ' Excel 97 is version 8.0
            .DialogSheets("dNames").Labels("lblText").Width = 94.5
        Else
            .DialogSheets("dNames").Labels("lblText").Width = 90
        End If
    End With
End Sub