How to do Error handling for an Excel vba code?

[ravikumar00008]

Hi All,

Can anyone help me how to do error handling with a sample code?

Thanks in advance.

Regards
Kumar

[Kyle123]

Something like

Please Login or Register  to view this content.

[ravikumar00008]

Hi Kyle,

Thanks for you once again responding in this post also.

Actually I have some doubts on this concept.

->Is it enough to write like what you have sent.

What about try , catch concept in this Excel VBA.

Regards
Kumar

[Kyle123]

Try catch doesn't exist in vba

[ravikumar00008]

Kyle,

Thanks for that.

As per your given handler.I will get only the message of the error.

1->Along with that , Is it possible the error occurred in which line?

2->Is it possible to provide our custom messages?

Regards
Kumar

[Kyle123]

1. Not by default - I believe there are addins which can do this.
2. You can put whatever you like in a messagebox

[ravikumar00008]

Kyle,

What about
1. Error.HelpContext
2. Error.HelpFile
3. Error.LastDllError
4.Error.Raise
5 Error.Source

Regards
Kumar

[Kyle123]

What about doing some research?

This site helps people who have issues, it isn't, nor could it be a comprehensive guide to learning all things VBA. Try having a google, there's loads out there - Chip Pearson's site will cover most of what you want.

[ravikumar00008]

Kyle,

Sorry for that.

There is a reason to ask you about those.
Because when i use Error.Number in a MsgBox , It is showing some number.Is it a line number or predefined code to identify that error?

Regards
Kumar

[Kyle123]

No, as I've already mentioned - you can't get the line number easily.

It is the error id