So I have some code that checks input data for errors and highlights the errors and displays that, it also currently counts the errors and gives a total.
What I'd like to do is add some kind of VBA that when an error is found it would write the specific error to another sheet (tab) in the same WB.
So, what I'd like to happen is as my segments of error checking code find an error they would then call this new VBA code that would write some specific text to this other Tab calling out the Row # that the error was found in and maybe even have a link to the specific cell with the error. I'd also like it to write some text next to the link or row number that gives a description of the error. I'd pass that description based on the type of error found when the segments of my code find it.
There are currently about 20-30 different errors being checked for and some of them can have multiple errors on the same data point (same cell). So I'd like to be able to specify what the specif error is if possible.
Not sure if posting my code would help as it is long and not well written, but it is working. I was hoping to see how some code for this might work and I could then add it to my existing code.
thanks in advance for any help or guidance on this, I'm not really sure how to even try and do this with VBA.
Phil
What I'd like to do is add some kind of VBA that when an error is found it would write the specific error to another sheet (tab) in the same WB.
So, what I'd like to happen is as my segments of error checking code find an error they would then call this new VBA code that would write some specific text to this other Tab calling out the Row # that the error was found in and maybe even have a link to the specific cell with the error. I'd also like it to write some text next to the link or row number that gives a description of the error. I'd pass that description based on the type of error found when the segments of my code find it.
There are currently about 20-30 different errors being checked for and some of them can have multiple errors on the same data point (same cell). So I'd like to be able to specify what the specif error is if possible.
Not sure if posting my code would help as it is long and not well written, but it is working. I was hoping to see how some code for this might work and I could then add it to my existing code.
thanks in advance for any help or guidance on this, I'm not really sure how to even try and do this with VBA.
Phil