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.

Syntax

expression.PointsToPicas(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 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



Show: