Managing Cell Controls in Worksheets
Accessing Cell Controls
To access and modify an existing cell control in the worksheet, developers can access a specific cell control from the Controls collection of the Worksheet by specifying the cell (using cell name or its location in terms of row and column numbers) in which the cell control is being displayed. Once a cell control is accessed, developers can modify its properties at runtime. For an instance, in the example given below, we have accessed an existing CheckBox cell control from the Worksheet and modified its Checked property.
IMPORTANT: Controls collection contains all types of cell controls in the form of CellControl objects. So, if you need to access a specific type of cell control, say CheckBox then you will have to typecast the CellControl object to CheckBox class.
Removing Cell Controls
To remove an existing cell control, developers can simply access a desired worksheet and then Remove the cell control from the Controls collection of the Worksheet by specifying the cell (using its name or row & column number) containing cell control.