This documentation is archived and is not being maintained.

Application.PointsToPicas Method

Office 2007
Converts a measurement from points to picas (1 pica = 12 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 36 points to the corresponding number of picas.

Visual Basic for Applications
MsgBox PointsToPicas(36) & " picas"

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