CheckBoxes Method

Applies To

Chart Object, DialogSheet Object, Worksheet Object.

Description

Accessor. Returns an object that represents a single check box (a CheckBox object, Syntax 1) or a collection of check boxes (a CheckBoxes object, Syntax 2) on the sheet.

Syntax 1

object.CheckBoxes(index)

Syntax 2

object.CheckBoxes

object

Required. The Chart, DialogSheet, or Worksheet object.

index

Required for Syntax 1. Specifies the name or number of the check box (can be an array to specify more than one).

Example

This example sets check box one on Dialog1 to be gray and then displays the dialog box.

With DialogSheets("Dialog1")
    .CheckBoxes(1).Value = xlMixed
    .Show
End With