Description
Represents an oval graphic object on a chart sheet, dialog sheet, or worksheet.
Accessors
The Oval object is a member of the Ovals collection. The Ovals collection contains all the Oval objects on a single sheet. Use the Add method (or click the Ellipse or Filled Ellipse button on the Drawing toolbar) to create a new oval and add it to the collection. To access a single member of the collection, use the Ovals method with the index number or name of the oval as an argument.
The following example sets the border color for oval one.
Worksheets("Sheet1").Activate
ActiveSheet.Ovals(1).Border.Color = RGB(0, 255, 255)
The oval name is shown in the Name Box when the oval is selected. Use the Name property to set and return the oval name.
The following example selects the oval named "Oval 1" on the active sheet and then sets the oval interior color.
Worksheets("sheet1").Activate
ActiveSheet.Ovals("oval 1").Select
Selection.Interior.Color = RGB(255, 0, 0)
Properties
Application Property, Border Property, BottomRightCell Property, Creator Property, Enabled Property, Height Property, Index Property, Interior Property, Left Property, Locked Property, Name Property, OnAction Property, Parent Property, Placement Property, PrintObject Property, Shadow Property, Top Property, TopLeftCell Property, Visible Property, Width Property, ZOrder Property.
Methods
BringToFront Method, Copy Method, CopyPicture Method, Cut Method, Delete Method, Duplicate Method, Select Method, SendToBack Method.