GrapeCity.Documents.Excel.Forms.IControlCollection.AddSpinner

AddSpinner Method

AddSpinner(double, double, double, double)

Adds a new ISpinner.

Use this method to place a spinner form control on the worksheet and then configure its linked cell and range settings through the returned ISpinner.

Declaration

ISpinner AddSpinner(double left, double top, double width, double height)

Function AddSpinner(left As Double, top As Double, width As Double, height As Double) As ISpinner

Parameters

Type	Name	Description
double	left	The horizontal position of the spinner.
double	top	The vertical position of the spinner.
double	width	The width of the spinner.
double	height	The height of the spinner.

Returns

Type	Description
ISpinner	The newly created ISpinner.

Examples

ISpinner spinner = worksheet.Controls.AddSpinner(20, 20, 18, 72);
spinner.LinkedCell = worksheet.Range["A1"];
spinner.Min = 0;
spinner.Max = 10;
spinner.SmallChange = 1;