This page:
https://bettersolutions.com/vba/erro...ing-errors.htm
says:
"If you are generating errors, then you should add your number to the vbObjectError constant. Eg Err.Raise Number = vbObjectError + 1000
The range 513 - 65535 is available for user defined errors"
Ok, but i did, and got a native error:
Err.Raise vbObjectError+515
Automation error
A syntax error occurred trying to evaluate a query string
This site
https://exceldevelopmentplatform.blo...criptions.html
says the error code for that error-message is
EVENT_E_QUERYSYNTAX As Long = &H80040203
The VBA immediate pane confirms this:
bettersolutions.com also says:
"The range 513 - 65535 is available for user defined errors"
If i'm supposed to add vbObjectError, and if 513-65535 is usable, then why does `Err.Raise vbObjectError+515` give me a native error!?
also O'Reilly says:
"we are left with numbers in the range vbObjectError + 512 to vbObjectError + 65535"
https://www.oreilly.com/library/view...0/ch09s04.html
Ok, let's say they mean my custom codes should start at 513, and forget about vbObjectError. But their Codes page shows native errors of 520, 521, some 700's, and some 31000's.
https://bettersolutions.com/vba/erro...rror-codes.htm
Microsoft documentation give yet different instructions:
So, i can start at vbObjectError + 1?
i'm totally confused.
Thx!
also asked here
http://www.vbaexpress.com/forum/show...ng-as-Expected
Bookmarks