Catch data validation change event Excel 2007

[saucekorn69]

Hi guys,

I've implanted data validation into some cells and I need to be able to catch any modifications to these cells. If the user change the value from A to B, I would like to trap this event using VBA.

I've tried to record a macro, change the value of the cell using the data validation but unfortunately, it didn't generate any code at all.

Can someone point me in the right direction ?

Thank you !

Nicolas.

[saucekorn69]

I found it, I just have to catch the Worksheet change event !

I guess there is no other way to proceed...

Thanks anyways

[royUK]

Assuming the validation is in C2 try

Please Login or Register  to view this content.