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