Add Checkbox Excel 2016

  1. Add Checkbox In Excel 2016
  2. Add Checkbox Excel 2016
Add -->

To insert a checkbox in Excel, do the following: On the Developer tab, in the Controls group, click Insert, and select Check Box under Form Controls or ActiveX Controls. Click in the cell where you want to insert the checkbox, and it will immediately appear near that cell. To add a check box, click the Developer tab, click Insert, and under Form Controls, click. To add an option button, click the Developer tab, click Insert, and under Form Controls, click. Click in the cell where you want to add the check box or option button control. Tip: You can only add one checkbox or option button at a time.

Definition

Important

Add Checkbox Excel 2016

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.

2016

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

Inheritance
CheckBox
Attributes
DefaultEventAttributeDefaultPropertyAttributeToolboxItemAttribute

Remarks

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

Add Checkbox In Excel 2016

Do not use the New constructor to create a new CheckBox. Use the AddCheckBox method to add a new CheckBox to a worksheet.

Properties

Add Checkbox Excel 2016

AltHTML
Application

Gets an Application object that represents the creator of the CheckBox.

Border

Gets a Border that represents the border of the CheckBox.

Bottom

Gets the distance, in points, between the bottom edge of the CheckBox 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 CheckBox.

Creator

Gets a value that indicates the application in which the CheckBox was created.

Height

Gets or sets the height of the CheckBox.

Index

Gets the index number of the CheckBox within the collection of OLEObjects on the sheet.

Interior

Gets an Interior object that represents the interior of the CheckBox.

Left

Gets or sets the distance, in points, between the left edge of the CheckBox and the left edge of the worksheet.

Locked

Gets or sets a value that indicates whether the CheckBox 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 CheckBox.

Placement

Gets or sets an object that indicates the way the CheckBox is attached to the cells below it.

PrintObject

Gets or sets a value that indicates whether the CheckBox is printed when the worksheet is printed.

Right

Gets the distance, in points, between the right edge of the CheckBox and the left edge of the worksheet.

ShapeRange

Gets a ShapeRange object that represents the CheckBox.

SourceName

Gets or sets the link source name of the CheckBox.

Top

Gets or sets the distance, in points, between the top edge of the CheckBox 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 CheckBox.

Visible

Gets or sets a value that represents whether the CheckBox is visible.

Width

Gets or sets the width of the CheckBox in points.

ZOrder

Gets the z-order position of the CheckBox.

Methods

Activate()

Activates the CheckBox.

BringToFront()

Brings the CheckBox to the front of the z-order.

CopyPicture(XlPictureAppearance, XlCopyPictureFormat)

Copies the CheckBox to the Clipboard as a picture.

Delete()

Deletes a dynamically created CheckBox from the worksheet and removes it from the ControlCollection.

Select(Object)

Selects the CheckBox.

SendToBack()

Sends the CheckBox to the back of the z-order.

SetVisibleCore(Boolean)

Sets the CheckBox to the specified visible state.

Update()

Applies to