Vb net row validating
Or, if you don’t want to limit the code to a specific column, you could delete the two rows that are marked with a red circle.
To experiment with this technique, you can download the zipped sample file from the Contextures website, on the Excel Data Validation – Select Multiple Items page.
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.
There is also an option of showing a multi-select listbox, or a single-select version (this is helpful when working with dependent lists — you don’t want multiple items selected in the main columns).
The kit has 3 sample files, and a user guide, with details and screen shots, on how to add this technique to your own workbooks.
Ultra Edit supports 64-bit file handling on both 32-bit and 64-bit Windows platforms (Windows 7 and later).To try it for yourself, follow the download link for the sample file, near the end of this article.[Update]: Since posting this article on selecting multiple items from an Excel drop down list, I’ve added more articles on this topic.Instead of limiting users to a single selection, you can use a bit of programming, combined with the data validation list, and allow multiple selections.You can display all the selected items across a row, or down a column, or keep them in the same cell.