Applies To
Chart Object, DialogSheet Object, Worksheet Object.
Description
Accessor. Returns an object that represents a single option button control (an OptionButton object, Syntax 1) or a collection of option button controls (an OptionButtons object, Syntax 2) on the sheet.
Syntax 1
object.OptionButtons(index)
Syntax 2
object.OptionButtons
object
Required. The Chart, DialogSheet, or Worksheet object.
index
Required for Syntax 1. Specifies the name or number of the option button (can be an array to specify more than one).
Example
This example sets option button one on Dialog1.
Dialogsheets("Dialog1").OptionButtons(1).Value = xlOn