ScrollBar Class

Namespace:

GemBox.Spreadsheet.Drawing

Assembly:

GemBox.Spreadsheet.dll

Represents a Scroll Bar Form Control.

• C#
• VB.NET

public class ScrollBar : ExcelFormControl

Public Class ScrollBar
    Inherits ExcelFormControl

Inheritance:

System.Object

ExcelDrawing

ExcelFormControl

ScrollBar

Properties

CellLink

Gets or sets the cell which holds the value of this scroll bar.

• C#
• VB.NET

public ExcelCell CellLink { get; set; }

Public Property CellLink As ExcelCell

Property Value

ExcelCell

The cell which holds the value of this scroll bar.

CurrentValue

Gets or sets the value of the scroll bar.

• C#
• VB.NET

public int CurrentValue { get; set; }

Public Property CurrentValue As Integer

Property Value

System.Int32

The value of the scroll bar.

FormControlType

Gets the ScrollBar value.

• C#
• VB.NET

public override FormControlType FormControlType { get; }

Public Overrides ReadOnly Property FormControlType As FormControlType

Property Value

FormControlType

The ScrollBar value.

Overrides

ExcelFormControl.FormControlType

IncrementalChange

Gets or sets the increment which is added or subtracted when clicking on this scroll bar.

• C#
• VB.NET

public int IncrementalChange { get; set; }

Public Property IncrementalChange As Integer

Property Value

System.Int32

The increment which is added or subtracted when clicking on this scroll bar.

MaximumValue

Gets or sets the maximum value that can be produced by this scroll bar.

• C#
• VB.NET

public int MaximumValue { get; set; }

Public Property MaximumValue As Integer

Property Value

System.Int32

The maximum value that can be produced by this scroll bar.

MinimumValue

Gets or sets the minimum value that can be produced by this scroll bar.

• C#
• VB.NET

public int MinimumValue { get; set; }

Public Property MinimumValue As Integer

Property Value

System.Int32

The minimum value that can be produced by this scroll bar.

PageChange

Gets or sets the number of lines to move the scroll bar on a page click.

• C#
• VB.NET

public int PageChange { get; set; }

Public Property PageChange As Integer

Property Value

System.Int32

The number of lines to move the scroll bar on a page click.

Inherited Properties

Hyperlink	Gets or sets the hyperlink on this drawing (picture, chart, etc.). (Inherited from ExcelDrawing)
MacroName	Gets the name of the assigned vba macro to this button. (Inherited from ExcelFormControl)
Metadata	Gets the metadata (non-visual properties) of this ExcelDrawing instance. (Inherited from ExcelDrawing)
Position	Gets the position of this drawing (picture, chart, etc.) in the worksheet. (Inherited from ExcelDrawing)
Print	Gets or sets whether current form control is printable. (Inherited from ExcelFormControl)
ThreeDShading	Gets or sets whether 3D effect should be enabled on the current form control. (Inherited from ExcelFormControl)
Worksheet	Gets the parent worksheet. (Inherited from ExcelDrawing)
ZIndex	Gets the z-order position of the picture. -1 if the picture is not contained in proper collection. (Inherited from ExcelDrawing)

Inherited Methods

BringForward()	Moves the form control one position forward in the drawings. (Inherited from ExcelFormControl)
BringToFront()	Brings the form control to the front of the drawings. (Inherited from ExcelFormControl)
Format()	Formats this drawing (picture, chart, etc.) to its default size so it can be exported to PDF, XPS, image or be printed. (Inherited from ExcelDrawing)
Format(System.Double, System.Double, LengthUnit)	Formats this drawing (picture, chart, etc.) to specified size so it can be exported to PDF, XPS, image or be printed. (Inherited from ExcelDrawing)
MoveZIndex(System.Int32)	Moves the form control forward or backward in the drawings with the given relative index. (Inherited from ExcelFormControl)
SendBackward()	Moves the form control one position backward in the drawings. (Inherited from ExcelFormControl)
SendToBack()	Sends the form control to the back of the drawings. (Inherited from ExcelFormControl)
SetMacro(VbaModule, System.String)	Assigns the given macro to this button. (Inherited from ExcelFormControl)