ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help including exception handling - try block (https://www.excelbanter.com/excel-programming/395306-help-including-exception-handling-try-block.html)

hll

Help including exception handling - try block
 
Hi.. I know this is a "rookie" question so let me apologize to the forum
ahead of time.

However...

I am trying to include a Try block in to my code. However, there seems to
be no reference to whatever object holds this code as it does not understand
when I try to say something like this
Try

.....

END Try
I know I need to go in to "Tools-Reference" to add the correct module but
I have have no idea which object needs to be added. Can anyone help?
Also, is there a reference guide somewhere that tells you what "library" a
command is in?

Again, thanks in advance and for helping me out.

Ron Coderre

Help including exception handling - try block
 
There is no Try/Catch construct in VBA.

For error trapping, see the On Error statement in VBA Help

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"hll" wrote:

Hi.. I know this is a "rookie" question so let me apologize to the forum
ahead of time.

However...

I am trying to include a Try block in to my code. However, there seems to
be no reference to whatever object holds this code as it does not understand
when I try to say something like this
Try

....

END Try
I know I need to go in to "Tools-Reference" to add the correct module but
I have have no idea which object needs to be added. Can anyone help?
Also, is there a reference guide somewhere that tells you what "library" a
command is in?

Again, thanks in advance and for helping me out.



All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com