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
- Application
- Brightness
- ColorType
- Contrast
- Creator
- Crop
- CropBottom
- CropLeft
- CropRight
- CropTop
- Parent
- TransparencyColor
- TransparentBackground
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.