Using an Excel Event to Validate Each Row of Data in Real Time

**james_thomas007** · 06-12-2009, 08:38 AM

Hi all

I use a template which users fill in data (there are lists used in most of the cells to ensure that only appropriate values are entered but these are overwritten if a user pastes data into the cells) on a variable number of rows.

Depending on what they enter in certain cells in the same row will require different sets of validation.

I'd like to be able to have the flexibility to apply this validation on the set of variables the user has entered but I'd like to do this without them having to click a button to run a separate macro.

Is it possible to satisfy the requirement above using a worksheet event such as selectionchange, and if so, is it possible to use a variable to indicate which row it should apply the validation on

e.g. if they entered data in row A, and click in Row C, I'd like there to be some kind of error message saying row A contains the error.

As there will be an unknown number of rows, it would have to apply the validation each row.

Thanks a lot for reading this, and if you can help me with any of it, i'd really appreciate it!

**romperstomper** · 06-12-2009, 08:44 AM

If you are responding to manual entry, then the Worksheet_Change event will work. It provides a range argument (called Target) that represents the changed cell(s) so you know which row(s) you need to apply the validation to.