PictureFormat Members (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

Methods

Name

Description

IncrementBrightness

Changes the brightness of the picture by the specified amount. Use the Brightness property to set the absolute brightness of the picture.

IncrementContrast

Changes the contrast of the picture by the specified amount. Use the Contrast property to set the absolute contrast for the picture.

Properties

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

Brightness

Returns or sets the brightness of the specified picture or OLE object. The value for this property must be a number from 0.0 (dimmest) to 1.0 (brightest). Read/write Single.

ColorType

Returns or sets the type of color transformation applied to the specified picture or OLE object. Read/write .

Contrast

Returns or sets the contrast for the specified picture or OLE object. The value for this property must be a number from 0.0 (the least contrast) to 1.0 (the greatest contrast). Read/write Single.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Crop

Returns an Crop object that represents the cropping settings for the specified PictureFormat object. Read-only

CropBottom

Returns or sets the number of points that are cropped off the bottom of the specified picture or OLE object. Read/write Single.

CropLeft

Returns or sets the number of points that are cropped off the left side of the specified picture or OLE object. Read/write Single.

CropRight

Returns or sets the number of points that are cropped off the right side of the specified picture or OLE object. Read/write Single.

CropTop

Returns or sets the number of points that are cropped off the top of the specified picture or OLE object. Read/write Single.

Parent

Returns the parent object for the specified object. Read-only.

TransparencyColor

Returns or sets the transparent color for the specified picture as a red-green-blue (RGB) value. For this property to take effect, the TransparentBackground property must be set to True. Applies to bitmaps only. Read/write Long.

TransparentBackground

Use the TransparencyColor property to set the transparent color. Applies to bitmaps only. Read/write MsoTriState.