Applies To
Chart Object, DialogSheet Object, Worksheet Object.
Description
Accessor. Returns an object that represents a single spinner control (a Spinner object, Syntax 1) or a collection of spinner controls (a Spinners object, Syntax 2) on the sheet.
Syntax 1
object.Spinners(index)
Syntax 2
object.Spinners
object
Required. The Chart, DialogSheet, or Worksheet object.
index
Required for Syntax 1. Specifies the name or number of the spinner (can be an array to specify more than one).
Example
This example displays the current value of spinner one on Dialog1. This example can be used in the event procedure for the spinner, in which case the message box appears every time you click the spinner.
MsgBox DialogSheets("Dialog1").Spinners(1).Value