PointsToScreenPixelsY Method

Microsoft Office Web Components Visual Basic

expression.PointsToScreenPixelsY(Points)

expression    Required. An expression that returns a Window object.

Points   Required Long. The number of pixels to add to this method's result.

Remarks

Although the name of this method suggests that it will convert point values to screen pixel values, it actually performs the action described above using only pixel values. For the PointsToScreenPixelsY method, this value will vary depending on whether the toolbar (22 pixels) and column headers (17 pixels) are turned on.

Example

This example returns 40 when both the toolbar and column headers are turned on, and returns 1 when the toolbar and column headers are turned off.

Sub Window_OnLoad()

     MsgBox Spreadsheet1.ActiveWindow.PointsToScreenPixelsY(0)   

End Sub