Enhancing existing VBA.

[baxius]

Hello everyone,

I've managed to acquire and modify a simple macro to find and place a text in adjacent cells. The thing i could really use is some additional functions to it. What i need is to firmly verify that the data was entered where it should be and as it should be. To put it simply. The data is entered-->It is found and timestamped in another worksheet-->Active sheet switches to where the data was placed. If anyone has better ideas or a macro update, i thank you will all my heart.

Please Login or Register  to view this content.

[JBeaucaire]

What specifically would those "verifications" be you want to verify? We need to know what we're looking for in fine detail before any code can be suggested.

[baxius]

I would like to verify. Did the VBA produce the output in the correct worksheet

[JBeaucaire]

The code includes an alert messagebox that pops up when the code entered is not found in one of the other sheets. So NOT seeing that code means the prior "found" code did complete. To my eye this should suffice.

What has been your experience that makes you suspect this is not working?

[baxius]

Due to human failure some codes are not where they should be from the start. So when the VBA produces an output it would be good to double check. (Yes this can be manual, but most of the time more then 30 codes are entered and there are more then 30 sheets in the document.

[JBeaucaire]

Well, maybe you could a CHANGE LOG worksheet to your workbook and record what the changes made are.

A: Code entered
B: Sheet name where it was located
C: Cell address where it was located, or row number, whatever.
D: Whatever else would make your "log" complete.


You'd also need to add some code to your original macro to skip the log sheet when searching:

Please Login or Register  to view this content.