Description
A collection of all the Spinner objects on the specified chart sheet, dialog sheet, or worksheet. Spinners are often linked to edit boxes so that the user can select a numeric value without having to type in a number. Spinners are very similar to scroll bars (ScrollBar objects), but spinners do not have the LargeChange property.
Accessors
Use the Add method to create a new spinner and add it to the collection. The following example adds a new spinner to the worksheet named "Sheet1." The new spinner is 10 points wide and is located at the left edge of cell C5.
Dim r As Range
Set r = Worksheets("sheet1").Range("c5")
Worksheets("sheet1").Spinners.Add r.Left, r.Top, 10, r.Height
Use the Spinners method with an argument to access a single member of the collection or without an argument to access the entire collection at once. The following example deletes all of the spinners on the worksheet named "Sheet1."
Worksheets("sheet1").Spinners.Delete
Properties
Application Property, Count Property, Creator Property, Display3DShading Property, Enabled Property, Height Property, Left Property, LinkedCell Property, Locked Property, Max Property, Min Property, OnAction Property, Parent Property, Placement Property, PrintObject Property, SmallChange Property, Top Property, Value Property, Visible Property, Width Property, ZOrder Property.
Methods
Add Method (Graphic Objects and Controls), BringToFront Method, Copy Method, CopyPicture Method, Cut Method, Delete Method, Duplicate Method, Group Method, Item Method, Select Method, SendToBack Method.