ActiveX
To display a spin button in a percent cell
At run time,
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
- Set the Col, Col2, Row, and Row2 properties as appropriate.
- If you are selecting a block of cells, set the BlockMode property to True.
- Set the CellType property to 14 (Percent).
- Display a spin button in the cell by setting the TypeSpin property to True.
- Specify the amount by which the value in the cell is incremented or decremented when the user clicks the spin button using the TypeSpinInc property.
- Specify that the value in the cell wraps when the cell reaches the maximum or minimum value by setting the TypeSpinWrap property to True.
- If you selected a block of cells, set the BlockMode property back to False.