Cell validating c
You can use data validation to restrict the type of data or the values that users enter into a cell.
One of the most common data validation uses is to create a drop-down list.
However, the user may prefer to validate all the data cells in a row at once.
This scenario can be achieved by using the Row Validating event, which is fired when the user tries to change the current row (changing to another row or when the control loses focus).
The best thing about using a table is that as you add or remove items from your list, your data validation list will update automatically.