Excel actually can do data validation. You can allow input only on certain cells, and allow the input to take values only in a range. Alternatively, you could do the validation in VBA.