Malyalm sexchatting - Ways of validating data

by  |  09-Jul-2015 16:03

In the sample file, a macro runs automatically when the workbook opens, to protect the “Same Cell” worksheet.If you do not need that code, you can remove it from the This Workbook module.

ways of validating data-61ways of validating data-72

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.

NOTE: In some of the code, you might have to change the range names or the sheet names, if you copy the code to a different workbook.

Some code examples refer to a specific row or column number, and you might also need to adjust those.

If you remove or rename the Same Cell sheet, without deleting the Workbook_Open code, you will see an error message when the file opens.

Community Discussion