Vb net row validating
For example, each item selected in this drop down list fills the next empty cell at the right.
You could use this technique to fill player names across a list of innings, or employee names for days of the week.
Instead of selecting from the drop down, a list box appears when you click the cell.
It automatically selects any items that are already in the cell.
In the code shown below, column 3 is the only one where the change will occur.
There is a premium version of this technique, and you can see the details here: Data Validation Multi Select Premium.In some worksheets, you might prefer to fill down, instead of across.Instead of filling other cells, you can keep all the selections in the same cell, separated by commas.You’ve probably used an Excel data validation drop down list, where you can click the arrow, and select an item to fill the cell.
In the worksheet shown below, you can select a month from the drop down, and it overwrites any previous selection in that cell.
Click here for details: Data Validation Multi Select Premium.