Ovals Method

Applies To

Chart Object, DialogSheet Object, Worksheet Object.

Description

Accessor. Returns an object that represents a single oval (an Oval object, Syntax 1) or a collection of ovals (an Ovals object, Syntax 2) on the sheet. Read-only.

Syntax 1

object.Ovals(index)

Syntax 2

object.Ovals

object

Required. The object containing the ovals.

index

Required for Syntax 1. The name or number of the oval.

Example

This example deletes every oval on Sheet1.

Worksheets("Sheet1").Ovals.Delete

This example changes the color of oval one on Sheet1 to red.

Worksheets("Sheet1").Ovals(1).Border.ColorIndex = 3