This documentation is archived and is not being maintained.

Application.PointsToInches Method

Office 2007
Converts a measurement from points to inches (1 inch = 72 points). Returns the converted measurement as a Single.



expression   A variable that represents an Application object. Optional.


NameRequired/OptionalData TypeDescription
PointsRequiredSingleThe measurement, in points.

Return Value


This example converts the measurement of the top margin for the active document to inches and displays the result in a message box.

Visual Basic for Applications
MsgBox PointsToInches(ActiveDocument.Sections(1) _

This example converts the value of the variable sngData (a measurement in points) to centimeters, inches, lines, millimeters, or picas, depending on the value of the variable intUnit (a value from 1 through 5 that indicates the resulting unit of measurement).

Visual Basic for Applications
Function ConvertPoints(ByVal intUnit As Integer, _
    sngData As Single) As Single

    Select Case intUnit
        Case 1
            ConvertPoints = PointsToCentimeters(sngData)
        Case 2
            ConvertPoints = PointsToInches(sngData)
        Case 3
            ConvertPoints = PointsToLines(sngData)
        Case 4
            ConvertPoints = PointsToMillimeters(sngData)
        Case 5
            ConvertPoints = PointsToPicas(sngData)
        Case Else
            Error 5
    End Select

End Function