Export (0) Print
Expand All
Expand Minimize

Application.PointsToInches Method

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

Syntax

expression.PointsToInches(Points)

expression   A variable that represents an Application object. Optional.

Parameters

NameRequired/OptionalData TypeDescription
PointsRequiredSingleThe measurement, in points.

Return Value
Single

Example

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) _
    .PageSetup.TopMargin)

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



Community Additions

ADD
Show:
© 2014 Microsoft