VScrollBar Class

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel.Controls

Assembly:: Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Represents a Windows Forms VScrollBar that can be added to a Microsoft Office Excel worksheet.

public ref class VScrollBar : System::Windows::Forms::VScrollBar

[System.ComponentModel.DefaultEvent("Scroll")]
[System.ComponentModel.DefaultProperty("Value")]
[System.ComponentModel.ToolboxItem(false)]
public class VScrollBar : System.Windows.Forms.VScrollBar

[<System.ComponentModel.DefaultEvent("Scroll")>]
[<System.ComponentModel.DefaultProperty("Value")>]
[<System.ComponentModel.ToolboxItem(false)>]
type VScrollBar = class
    inherit VScrollBar

Public Class VScrollBar
Inherits VScrollBar

Inheritance: VScrollBar
VScrollBar

Attributes: DefaultEventAttribute DefaultPropertyAttribute ToolboxItemAttribute

Remarks

The Microsoft.Office.Tools.Excel.Controls.VScrollBar is different from a System.Windows.Forms.VScrollBar. The Microsoft.Office.Tools.Excel.Controls.VScrollBar has additional members that enable it to be added to an Excel worksheet and that give it additional methods and properties.

Do not use the New constructor to create a new VScrollBar. Use the AddVScrollBar method to add a new VScrollBar to a worksheet.

Properties

AltHTML
Application	Gets an Application object that represents the creator of the VScrollBar.
Border	Gets a Border that represents the border of the VScrollBar.
Bottom	Gets the distance, in points, between the bottom edge of the VScrollBar and the top edge of the worksheet.
BottomRightCell	Gets a Range object that represents the cell that lies under the lower-right corner of the VScrollBar.
Creator	Gets a value that indicates the application in which the VScrollBar was created.
Height	Gets or sets the height of the VScrollBar.
Index	Gets the index number of the VScrollBar within the collection of OLEObjects on the sheet.
Interior	Gets an Interior object that represents the interior of the VScrollBar.
Left	Gets or sets the distance, in points, between the left edge of the VScrollBar and the left edge of the worksheet.
Locked	Gets or sets a value that indicates whether the VScrollBar can be modified at design time when the sheet is protected.
OLEType	Gets a value that represents the OLE object type.
OnAction
Parent	Gets the parent object for the VScrollBar.
Placement	Gets or sets an object that indicates the way the VScrollBar is attached to the cells below it.
PrintObject	Gets or sets a value that indicates whether the VScrollBar is printed when the worksheet is printed.
Right	Gets the distance, in points, between the right edge of the VScrollBar and the left edge of the worksheet.
ShapeRange	Gets a ShapeRange object that represents the VScrollBar.
SourceName	Gets or sets the link source name of the VScrollBar.
Top	Gets or sets the distance, in points, between the top edge of the VScrollBar and the top edge of the worksheet.
TopLeftCell	Gets a Range object that represents the cell that lies under the upper-left corner of the VScrollBar.
Visible	Gets or sets a value that represents whether the VScrollBar is visible.
Width	Gets or sets the width of the VScrollBar in points.
ZOrder	Gets the z-order position of the VScrollBar.

Methods

Activate()	Activates the VScrollBar.
BringToFront()	Brings the VScrollBar to the front of the z-order.
CopyPicture(XlPictureAppearance, XlCopyPictureFormat)	Copies the VScrollBar to the Clipboard as a picture.
Delete()	Deletes a dynamically created VScrollBar from the worksheet and removes it from the ControlCollection.
Select(Object)	Selects the VScrollBar.
SendToBack()	Sends the VScrollBar to the back of the z-order.
SetVisibleCore(Boolean)	Sets the VScrollBar to the specified visible state.
Update()

Applies to

Compartilhar via