Hi,
Background:
I have a macro that is used by the end user to validate if the code they input in a form will be accepted in our system or not. They input the coding in a specific range of cells (say B20:E40) and press the macro which returns a message in the column N which says whether the code was successful or invalid. So if the coding in row 20 is invalid the macro returns a message in N20 that says invalid.
The problem with this structure is when the coding is changed or deleted from the row, the message in column N remains the same until they re-run the macro.
Event Macro:
I want to create an event macro to be triggered in the event that any cell in range(B20:E40) is changed to identify that the code needs to be re-validated. I am able to create this using this simple macro:
Here's my problem and sorry it took so long to get to the point, if the code in the row is erased I want the message in column N to disappear.Please Login or Register to view this content.
Outcome:
So if the coding is changed in a row, column N in that row = "Validation Required", if no code in the row, column N = "". Then once the validation macro is ran column N is replaced with "success"or "invalid". From there any change or deletion of rows will results in one of the two outcomes created by the event macro.
I hope that makes sense, let me know if you need more information.
Thanks,
Nick
Note: Solved in Cross-post
http://vbaexpress.com/forum/showthread.php?t=43561
Bookmarks