Skip to content

Latest commit

 

History

History
64 lines (45 loc) · 2.07 KB

Excel.PictureFormat.md

File metadata and controls

64 lines (45 loc) · 2.07 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PictureFormat object (Excel)
vbaxl10.chm113000
vbaxl10.chm113000
Excel.PictureFormat
7e8ec723-b6e0-fdc9-ff4e-22cbb31be4df
03/30/2019
medium

PictureFormat object (Excel)

Contains properties and methods that apply to pictures and OLE objects.

Remarks

The LinkFormat object contains properties and methods that apply to linked OLE objects only. The OLEFormat object contains properties and methods that apply to OLE objects whether or not they're linked.

Example

Use the PictureFormat property of the Shape object to return a PictureFormat object. The following example sets the brightness, contrast, and color transformation for shape one on myDocument and crops 18 points off the bottom of the shape. For this example to work, shape one must be either a picture or an OLE object.

Set myDocument = Worksheets(1) 
With myDocument.Shapes(1).PictureFormat 
 .Brightness = 0.3 
 .Contrast = 0.7 
 .ColorType = msoPictureGrayScale 
 .CropBottom = 18

Methods

Properties

See also

[!includeSupport and feedback]