error trapping not working?

[Lifeseeker]

Hello,

I have the following code in VBA:

Please Login or Register  to view this content.

My error catching is just that line " on error goto error_catching, and at the bottom of the code, I have

Please Login or Register  to view this content.

all of my codes are in the worksheet_change event.

When I run it, say for example, I type in....7/4/abdf instead of 7/4/2011, VBA still breaks into debug mode without invoking the error handler.

Is there a way around this?

Thank you

[protonLeah]

on error... has to preceed the code line that may trigger an error, i.e. the addition line.

[Lifeseeker]

so far I have..

Please Login or Register  to view this content.

and at the top, i have

Please Login or Register  to view this content.

When I type in 7/4/abcd, I have the msgbox pops up twice, but then VBA run-time window appears. How do I make it so that the VBA run-time error window doesn't appear at all, and after seeing the message, users would then make the correction reasonably?

By the way, I"m not sure why the msgbox popps twice.

Any ideas?

[Lifeseeker]

anybody able to assist?

[protonLeah]

Can you post the complete code? Error handlers are put at the end, not at the top, of a module and usually include what to do when the error is fixed.

[OnErrorGoto0]

You also need to ensure that you have an Exit Sub line before the error handler section to ensure it doesn't get run every time even if there is no error.

[Lifeseeker]

Can you post the complete code? Error handlers are put at the end, not at the top, of a module and usually include what to do when the error is fixed.

THere you go. Please see the attached.

In worksheet "Test", so if you type in cells in col 7 or 8, or G or H, for example, 7/4/abcd, it will go to the problem.

I'm basically combining the date with the time.

Thanks

[Lifeseeker]

You also need to ensure that you have an Exit Sub line before the error handler section to ensure it doesn't get run every time even if there is no error.

Hi,

Would you mind taking a look at it please?

[snb]

Please Login or Register  to view this content.

[Lifeseeker]

Hi snb,

When I replace my code with yours, I still get the type mismatch run-time error. This is because I have set the column 7's format to be date and column 8's format to be 24hrs time.

Any ideas?

My concern was...I would prefer that VBA continues to run even when it has encountered a problem. How do I make it so that the normal flow of the program won't be interrupted?

Thanks

[royUK]

You should structure the error trapping like this

Please Login or Register  to view this content.

[snb]

This is not about formatting but about values.

Please Login or Register  to view this content.

[Lifeseeker]

hi there,

Right now, if I type in 7/4/201b, the program does tell users where the error has occurred and I am able to go in and correct the error.

However, after a correction is made, the program doesn't seem to be going forward, and it seems to be hung at the previous error even though the error has now been corrected.

Is there a way around this?

Thank you

[Lifeseeker]

Is anyone able to assist?

[royUK]

I think you are trying to detect an error in the user's input. The error trapping in the code is designed to detect errors in the code.

[OnErrorGoto0]

You might use something like

Please Login or Register  to view this content.

[Lifeseeker]

wow nice, worked like a charm.

Actually I added one line as it the .clearcontents doesn't appear to clear the combined date/time field at the later column, which might cause inconsistencies in data. But overall thank you again!

Please Login or Register  to view this content.