SSpread.TypeCurrencyMax Property

Set the maximum value that can be entered in a currency type cell.

Only valid for cells with the CellType property set to $CellTypeCurrency. Before setting this property, use the Col , Row properties etc. to specify what you want to process.

The initial value is 9999999.99 .

The lower limit is specified by the TypeCurrencyMin property. The spin button displayed by the TypeSpin property allows you to increase or decrease the value within the specified range. When the TypeSpinWrap property is set to $TRUE , the values ​​that have reached the upper and lower limits are wrapped.

This property is subject to property inheritance of currency type cells.

Precautions for specifying the range based on the lower and upper limits

Use case

Col = 3;
Row = 2;
CellType = $CellTypeCurrency;
TypeCurrencyMin = 0;
TypeCurrencyMax = 100;
Value = 0;
 
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeCurrency;
TypeCurrencyMin = -100;
TypeCurrencyMax = 100;
Value = 0;
BlockMode = $FALSE;

Related item
CellType , TypeCurrencyMin , TypeSpin , TypeSpinWrap property