Results 1 to 10 of 52

Thread: Resume On Error GoTo 0 -1 GoTo Error Handling Statements Runtime VBA Err Handling ORNeRe GoRoT N0Nula 1

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,452
    Rep Power
    10

    Resume On Error GoTo 0 -1 GoTo Error Handling Statements Runtime VBA Err Handling ORNeRe GoRoT N0Nula 1

    Link to get to Page 2 ( using 2 above right, or square with page number generally, sometimes does not work due to number at end of title ) :
    http://www.excelfox.com/forum/showth...0559#post10559

    _.__________________________

    https://excelfox.com/forum/showthrea...9877#post19877 Page 3
    https://excelfox.com/forum/showthrea...0Nula-1*/page3 Page 3


    https://www.excelfox.com/forum/showt...891&viewfull=1 page 4
    https://excelfox.com/forum/showthrea...0Nula-1*/page4 Page 4

    https://excelfox.com/forum/showthrea...ll=1#post19909 Page 5
    https://excelfox.com/forum/showthrea...0Nula-1*/page5 Page 5

    https://excelfox.com/forum/showthrea...ll=1#post19906 Page 6


    __________________________________________________ ______________________________________________


    This is post https://excelfox.com/forum/showthrea...ll=1#post10549






    Resume On Error GoTo 0 -1 GoTo Error Handling Statements, Error and VBA Error Handling in Runtime
    Erections/ arousing of Exceptional states by Error, 2018

    ORNeRe GoRoT N0Nula 1
    The Glorious State of Exception in Transalvania

    Hi
    I wrote for myself and shared some notes on this a couple of years ago.
    https://app.box.com/s/8zkhjcmbxrqnlnexqpktuy41clgqm4zo
    ( and here these current new notes in word docm format with codes also: Errors and Error Handling in VBA 2018 )

    I think they are fairly complete, but never the less , I usually end up trying test code examples to remind me of what is going on.
    It seems like an awkward subject, or is organised in a seemingly odd way, and unfortunately always seems to need a bit of thought or revision
    Some people asked me to share some simple examples_..

    _.. Here we go then, these will be a bit more practical and less theoretical than the notes, but a read of those notes as well probably does no harm. I will try a slightly different approach, just by way of a change. In the end though, I think I could end up just as long: I think this subject is not so difficult to master, its actually quite easy, bit almost nobody gets it completely correct. Possibly this is just because there are some strange syntaxes and the amount to learn is just that little too long for anyone to want read for a subject which on the face of it should be short, since for most real Object Oriented Programming, the try-catch structure would be the standard for just about everything, but instead VBA is an unholy alliance of MS Basic and sort-of-objects – ( Jay Freedman : https://eileenslounge.com/viewtopic....305700#p305700 )




    https://i.postimg.cc/L5tmj8Jc/VBA-De...or-Handler.jpg https://i.postimg.cc/L5KHq18k/VBA-De...r-Div-by-0.jpg



    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Attached Images Attached Images
    Last edited by DocAElstein; 10-02-2023 at 12:56 PM. Reason: Jay Freedman : https://eileenslounge.com/viewtopic.php?p=305700#p305700

Similar Threads

  1. Replies: 8
    Last Post: 09-01-2015, 01:50 AM
  2. Difference Between 'On Error GoTo 0' And 'On Error GoTo -1'
    By Transformer in forum Familiar with Commands and Formulas
    Replies: 7
    Last Post: 07-02-2015, 04:07 PM
  3. Replies: 2
    Last Post: 05-14-2013, 01:02 AM
  4. Runtime Error 481 invalid figure when PNG
    By Tony in forum Excel Help
    Replies: 0
    Last Post: 02-12-2013, 12:59 AM
  5. Replies: 10
    Last Post: 04-07-2012, 05:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •