Data Validation On Entry

My company has a very large spreadsheet with several people that add data. We want to add more data validation to the fields. I am an experienced programmer (Java, C++, etc..) but have no experience with Excel. I understand the basics of VBA, but am not too comfortable with the excel environment yet. What I would like to do is be able to run a function whenever data is entered into any row in column x. For the function I would need to know what row was edited so I can check it.

Something like:

Please Login or Register  to view this content.

I just don't know how to add a hook to the worksheet to run the function when the data changes. Thanks for helping me out.

Hi mroctogon,

in excel there is a event called 'Worksheet_Change(ByVal Target As Range)'.

this will basically fire every time a value in a cell has been changed. so you could basically do the following.

Please Login or Register  to view this content.

this would be for any cell changed in column 24 (col x)

altho there are built in data validation under the data>validation

yea the built in is rather basic. i always tend to use my own coded validation (so used to vb.net lol)

to get the range that has changed you can use this method of the target variable

Please Login or Register  to view this content.

and that will return for example $H$20:$H$30

You can iterate through the cells in Target:

Please Login or Register  to view this content.