Description
Option buttons allow the user to select one of a group of options. Option buttons are usually placed within a group box control (GroupBox object). You can set the position and size of an option button. On a worksheet or chart, you can also format the border and background. The font is fixed.
Accessors
The OptionButton object is a member of the OptionButtons collection. The OptionButtons collection contains all the OptionButton objects on a single sheet. Use the Add method to create a new option button and add it to the collection.
To access a single member of the collection, use the OptionButtons method with the index number or name of the option button as an argument. The following example turns on option button one on the worksheet named "Sheet2."
Worksheets("sheet2").OptionButtons(1).Value = xlOn
The option button name is shown in the Name Box when the option button is selected. Use the Name property to set or return the option button name. The following example disables the option button named "Option Button 13" on the worksheet named "Sheet2."
Worksheets("sheet2").OptionButtons("option button 13").Enabled = False
Properties
Accelerator Property, Application Property, Border Property, BottomRightCell Property, Caption Property, Creator Property, Display3DShading Property, Enabled Property, Height Property, Index Property, Interior Property, Left Property, LinkedCell Property, Locked Property, LockedText Property, Name Property, OnAction Property, Parent Property, PhoneticAccelerator Property, Placement Property, PrintObject Property, Text Property, Top Property, TopLeftCell Property, Value Property, Visible Property, Width Property, ZOrder Property.
Methods
BringToFront Method, Characters Method, CheckSpelling Method, Copy Method, CopyPicture Method, Cut Method, Delete Method, Duplicate Method, Select Method, SendToBack Method.