Data validator

Topic

New Reply

If you already have the logic and code to do the validation, you could put this in the Worksheet_Change Event. Assign a name to the range of input cells and then preface your code with a statement using the Intersect method to see if the active cell is in your named range. If so, run your code, if not exit.
HTH,

Reply | Quote

Replies

I’ve asked this before in the previous edition of this help group so I’ll hope for luck and try try again. Maybe the new year will bring me some resolution in this issue.
OK, I know how the code will go. It’s a simple select case statement

I want to verify the users data entry (a simple 3 digit value), in a select case statement. True allows the user to go next and False returns an error message. That part is easy. How do I go about placing this (module) in a range of 25-35 cells of one column? This will only check the contents of the current cell and run the script. No other references are necessary…
Any takers? WOW!! OK I missed something. There is a reference point and that is from a cell in the same row 2 columns back. This will be either a value, or a blank. God, I hope nulls aren’t applicable here.

Reply | Quote