SSpread.RestrictRows Property
Set whether to limit the input of one line apart.
Specify the following values. The initial value is $FALSE.
| Constant | Description |
|---|---|
| $TRUE | Cannot be entered unless a value is entered in the next row above (If you want to make sure that data is entered row by row) |
| $FALSE | Can be entered on any row. |
If you specify $ TRUE, you will not be able to enter one row at a time, so you can be sure to enter the value row by row. If you try to enter one row apart, you will hear a beep and the EditError event will occur.
Set the column input limit with the RestrictCols property.
Related Items
RestrictCols property
EditError event